Backboards: 
Posts: 154
In response to "You might try "Data->Text To Columns" and then split on the "." and repeat for the "@". -- nm" by Ender

Yeah, this is how you do it. First use "@" as the delimiter and that will get you a column with "first.last".

Then just use the "." to delimit that column and you'll get two columns, one with "first" and one with "last".

Responses:
Post a message   top
Replies are disabled on threads older than 7 days.