Hello,
I received a file that has text, numbers, and some more text in a string and I would like to break it out into 3 columns. Each cell contains a name, phone number, and email address, all in the same cell.
Example:
Tony Smith 123-456-7890 tony@smith.com
William Williamson 234-567-8901 x123 william@fakeemail.com
PJ Hin 345-678-9012 PJ@example.com
Unfortunately, the locations of the names, numbers, and emails aren't in the same spot. Is it possible to look this information up by spaces? For name can it look up the info before the second space, then after the 2nd space for number, and after the last space for email?
Thank you so much!
I received a file that has text, numbers, and some more text in a string and I would like to break it out into 3 columns. Each cell contains a name, phone number, and email address, all in the same cell.
Example:
Tony Smith 123-456-7890 tony@smith.com
William Williamson 234-567-8901 x123 william@fakeemail.com
PJ Hin 345-678-9012 PJ@example.com
Unfortunately, the locations of the names, numbers, and emails aren't in the same spot. Is it possible to look this information up by spaces? For name can it look up the info before the second space, then after the 2nd space for number, and after the last space for email?
Thank you so much!