CODEWITHSUNDEEP
excelformulabreak
narue1992
narue1992

Reputation: 351

Split text in Excel cell when there is multiple deliminters

I have a list in a notepad that uses a comma for delimiter. The issue is this is the default and inside the second column( out of 2 columns) contains commas because its a few sentences each. How do I split the first and second column by the first comma in each row?

Ex:

Name, Info
----- ----
Parker, I have a dog by the name of Parker, and he loves to play dead. 
John Smith, John Smith married Elizabeth. Elizabeth has married on person before him, so this is now her second marriage.

Ps: this is not the actual information I have. Just an example.

I am looking for any advice with a formula to use in Excel or process if possible.

Thanks

Upvotes: 0

Views: 80

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

Place all the text in A1 and in B1 enter:

=LEFT(A1,FIND(",",A1)-1)

and in C1 enter:

=MID(A1,FIND(",",A1)+1,9999)

For example:

enter image description here

Upvotes: 1

Related Questions