Put column values in single quotes?

  • Thread starter Thread starter Jim Bancroft
  • Start date Start date
J

Jim Bancroft

Hi everyone,

I need to take a column of numbers and transform it, so that each value
is quoted.
For instance, transfer this:

200347323
263637827
273633727
..
..


to this:

'200347323'
'263637827'
'273633727'


Can you reccomend a way to do it? Thanks.
 
Hi Jim
in the adjacent column insert the following for the first row
="'" & A1 &"'"
copy down

HTH
Frank
 
Hi Jim

Simply if your data is in A2:A100, then in B2 use ="'"&A2&"'" copy down,
then copy / pastespecial values to another column and delete previous columns.
Yours,
Mathew

"Jim Bancroft" <bobbgambles_at_nospam.msn.com> wrote in message Hi everyone,

I need to take a column of numbers and transform it, so that each value
is quoted.
For instance, transfer this:

200347323
263637827
273633727
..
..


to this:

'200347323'
'263637827'
'273633727'


Can you reccomend a way to do it? Thanks.
 
Back
Top