Add " to text

  • Thread starter Thread starter JC
  • Start date Start date
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
 
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 *
 
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
 
I received two responses but for some reason I am getting
a message unavailable message. Could you reply to my
email at (e-mail address removed). Thank you AWJ and Trevor.
JC
 
Back
Top