• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Converting excel data into word with comma

R

reachkiran03

New Member
Sir I have database created in excel sheet.Name Gender Contact No - Residence Mobile Email

There are five columns as of now. I want the email id's column to be copied into worksheet, then it should be seperated by commas in the word how to do it. can any one help me.
 
Reachkiran03


Lookup the Concat function using the Chandoo.org Google Custom a search box top right of this page

Then use that to join all the email addresses together using a , as a delimiter

Once that is done copy the cell and paste into word


Here is the shortcut: http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/
 
You must log in or register to reply here.
Back
Top