Education

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

!! 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!!!!!

About the author

Related Posts

One Comment

  • Mohit Vats May 12, 2015 at 11:33 am

    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

    Reply

Leave a Reply

Leave a Reply

Your email address will not be published.