G
Guest
I have a set of 400 names and email addressed that I am trying to separate
into three colums: last name first name email address. I have pasted the
whole file into one cell and used the "Data Text to colum" command and it
separates the delimited ASCII file into the 3 components BUT across colums in
row 1 AND does not spearate all of them out because there are too many sets
of names and email addresses and too few columns.
What can I do to get the 3 colums of data I need?
into three colums: last name first name email address. I have pasted the
whole file into one cell and used the "Data Text to colum" command and it
separates the delimited ASCII file into the 3 components BUT across colums in
row 1 AND does not spearate all of them out because there are too many sets
of names and email addresses and too few columns.
What can I do to get the 3 colums of data I need?