Add " to text

J

JC

I need to add " to the beginning and end of text in a
column:

one
two
three

change to
"one"
"two"
"three"

Any ideas?
Thanks,
JC
 
A

A.W.J. Ales

JC,

Assuming one is in cell A1

=""""&A1&""""

Mark : There are four " before athe first and after the last &

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
T

Trevor Shuttleworth

JC

assuming your data is in column A, starting in A1, put the following formula
in another column and drag down:

="""" & A1 & """"

note that is 4 x " at the beginning and end

If you then copy the new column, you can Paste Special | Values over the
original data

Regards

Trevor
 
Top