I have a text file of email addresses that are separated by commas's but not in separate rows. I need to import them and have them all show up in one column. the way it happens now is they all go into multiply columns in row one.![]()
I have a text file of email addresses that are separated by commas's but not in separate rows. I need to import them and have them all show up in one column. the way it happens now is they all go into multiply columns in row one.![]()
Hi,
At present its copied in different columns you mentioned.
Now you copy that ...
and right click somewhere... select paste special.... Transpose
Shijesh Kumar
http://shijesh.wordpress.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks