String Modification in Excel

[Bass71]

Hello:

I am trying to add characters(a double quote) to the beginning and the end of a text string in an excel cell, assuming certain conditions are met. I'm not sure if I have to use the Left/Right Functions or some derivation of what I have attempted below:

If ActiveCell.Value <> &quot;&quot; Then
ActiveCell.Value = &quot;&quot;&quot; & ActiveCell.Value & &quot;&quot;&quot;
End If

Thanks so much...................RO

 

[lameid]

You need to double up quotes in strings delimeted by the same type of quote....

ActiveCell.Value = &quot;&quot;&quot;&quot; & ActiveCell.Value & &quot;&quot;&quot;&quot;

Or use single quote delimeted strings:

ActiveCell.Value = '&quot;' & ActiveCell.Value & '&quot;'


I stick to the former because two single quotes for one single quote in a single quote delimeted string can look like a double quote and really confuse matters <as if talking about it doesn't>.