Mid/Find Formula Help

KALESHIRE

I have this indexed @row info to a column named "AR" (Format will always be like this and no middle name). I need to split First two words to column named "Name", Split email to column named "Email" and split phone number to column named "Phone".

FirstName LastName Email@email.net 888-888-8888

Split to 3 columns:

1. "Name": FirstName Last Name
2. "Email": Email@email.net
3. "Phone": 888-888-8888

I have this formula for the Name, but it is not working.

=MID(AR@row, 1, FIND(" ", AR@row) - 1) + MID(AR@row, FIND(" ", AR@row) + 1, FIND(" ", AR@row, FIND(" ", AR@row) + 1) - FIND(" ", AR@row))

I've also tried this in the Name column, but it only returns the first name:

=LEFT(AR@row, FIND(" ", AR@row, FIND(" ", AR@row)))

Thanks!

heyjay

Name =SUBSTITUTE(SUBSTITUTE(Table@row, Email@row, ""), Phone@row, "")

Email =MID(SUBSTITUTE(Table@row, Phone@row, ""), FIND(" ", SUBSTITUTE(Table@row, Phone@row, ""), FIND(" ", SUBSTITUTE(Table@row, Phone@row, "")) + 1) + 1, LEN(SUBSTITUTE(Table@row, Phone@row, "")) - FIND(" ", SUBSTITUTE(Table@row, Phone@row, ""), FIND(" ", SUBSTITUTE(Table@row, Phone@row, "")) + 1))

Phone =RIGHT(Table@row, 12)

KALESHIRE

@heyjay - The Name/Email formulas are showing an error "UNPARSEABLE".

heyjay

Can you please send the formula that is on your sheet/cell?

Paul Newcome

I believe this may be a duplicate post?

Left, Right, Find, Formula Help!

KALESHIRE

Jul 30, 2024

I need help creating formulas to split cell information.

One cell contains indexed information in this string format:

FirstName LastName Email@Email 888-888-8888

I need the formula to split to each of these 3 columns

1. FirstName LastName
2. Email
3. Phone

Thank you!

---

View Post