how to separate email ids in Excel sheet

October 14, 2016 at 22:19:07
Specs: Windows 64
how to separate email ids in excel sheet...from name,designation,email id in one line..
i want to know is there any simple method to separate emails.Without copying one by one


See More: how to separate email ids in Excel sheet

Reply ↓  Report •


#1
October 15, 2016 at 01:33:24
open the list " name,designation,email " as .cvs.
Excell will ask what character "seperates" the values. In your case Comma??
Excell will display the values in separate columns, one row per listed line

Reply ↓  Report •

#2
October 15, 2016 at 20:18:43
If you post an example of your data, we might be able to offer a suggestion specific to your situation.

Please click on the following line and read the instructions on how to post example data in this forum. Thanks.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •

Related Solutions


Ask Question