Need to add a comma after the data in each cell?? -Windows 7 -Excel 2007 Spread

Question

Need to add a comma after the data in each cell??

-Windows 7

-Excel 2007

Spread sheet contains a column with nearly 2K contacts, which need a comma in each cell (following the data).

Ex:

*** Email address is removed for privacy ***

*** Email address is removed for privacy ***

*** Email address is removed for privacy ***

" "

" "

It needs to look like:

*** Email address is removed for privacy ***,

*** Email address is removed for privacy ***,

*** Email address is removed for privacy ***,

" "

" "

I've been copying them and pasting them to in sections of 100 to a Word document and manually adding the comma- it's taking a lifetime. Someone please help me figure this out. I've also researched a bit online. Someone said to save the excel doc as csv. then reopen, copy and paste to a Word doc and supposedly a comma should be there. It's not working for me.

Thank you so much!!!!!

Explanation / Answer

sAre those in different rows? if so, use this formula in B1 assuming data in A1:
=A1&"," >?

copy down. saving as csv or text will not work for you because it separates columns by commas

if you need to combine A1 with A2 & so on, then in B1:
=A1

in B2:
=B1&","&A2

copy down

1. select B1 where you have the formula i gave.
2. hover your mouse on the bottom right hand side of the selected cell
3. you should see a black cross (not the 4 directional arrows). double-click it to copy down all the way

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.