Adding Quotation marks to populated fields

P

pentatonic145

Hi! I have a spreadsheet with a bunch of columns (A, B, C, D etc.) eac
column has 421 fields. In each field is a unique 8-digit number.

Now, I need to take the numbers in the fields under Column C and pu
quotation marks around them, basically turning this:

12345686
32165482
15659875
12546586

into this:

"12345686"
"32165482"
"15659875"
"12546586"

But HOW man, how does I doing that mang?

Please for helping to me - thnaks
 
B

Bob Phillips

For i =1 To Cells(Rows.Count,"C").End(xlUp).Row
Cells(i,"C").Value = """ & Cells(i,"C").Value & """
Next i

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"pentatonic145" <[email protected]>
wrote in message
news:p[email protected]...
 
A

ANdras

Hi there,

you can do it in a helping-column, like this:
=""""&C1&"""" <= 4 times " both, before and after
then copy downwards the formula and if you want to replace it to column C,
then ctrl + c and then paste/special/values

Any good?
Best regards,
ANdras
(Hungary)
 
P

pentatonic145

We are trying out this formula:

To take the data in cell C2 and put quotes around it, we are trying
this:

=""""&C2&""""&""

and it works!

BUT - we have to do the same thing now with column D, which contains
dates in this format: mm/dd/yyyy

When I apply that same formula to cell D2, which contains the data:

04/12/2005

it renders this:

"38454"

and I can't get it to convert back to mm/dd/yyy format! :-(

My goal is to get D2 (and D3 and D4 and all the other dates in column
D) to look like this:

"04/12/2005" ???
 
Top