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!
Solved! Go to 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!
Hi @aparna0208 ,
You can achieve that with a text to columns tool as shown below
Hope that helps,
Regards,
Angelos
@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:)