Parse

[aparna0208]

Hi,

I am looking for some help. Please see attached sample data. The names and emails are all in one cell separated by a comma. I want to split it into three different columns(one for first name, one for last name and one for email). Is there a way to do that? Thanks in advance!

[marcusblackhill · Accepted solution]

hey @aparna0208 !

You can use the text to columns tool and select to rename.

Look the attached file.

Mark as solution if that helps!

[AngelosPachis · Accepted solution]

Hi @aparna0208 ,

You can achieve that with a text to columns tool as shown below

Hope that helps,

Regards,

Angelos

[aparna0208]

@marcusblackhill @AngelosPachis Thanks for the quick response:) It worked and didn't know it was this easy and for some reason was trying with regex. But yeah got the output as expected. Thanks for your inputs:)