Hi I am using MS office's latest version of 2007 edition. I am trying to adjust list of around 250 email id's in a sheet. I copy pasted the list from text file and pasted in excel, but when I tried to past the list in excel, it added all the email id in one column only (A1) but I want them to be in separate rows..like A1,A2,A3 etc.. Can any one suggest how can I do that?? I can't copy paste those id's individually..so I need some formula to do them all at once. Thanks in Advance.
Have you tried to "Paste Special" and then use the "Transpose" option? I sometimes have to do that same function with keyword lists and its worked for me. Once you have pasted them in to the sheet (in column format), you can copy all the words then select a new cell then use the Paste Special.
If your data has names and emails separated by blank spaces, you can surely use 'text to column' under the data tools to accomplish this task! Regards, RightMan
excel will transform data automatically in column from text editor. try paste special feature and transpose option
you can go to get some important information from the other medias, you can attend this training so that you will know about it, at last you can seach out what you want at baidu at once!
Use notepad first then make one email per line then copy them all to your excel. That's usually what I do when I paste multiple websites in my excel by using notepad first so as to use the default font and formats.