!! I need help!!
-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!!!!!
are 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