Mid/Find Formula Help
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:
- "Name": FirstName Last Name
- "Email": Email@email.net
- "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!
Answers
-
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)
...
-
@heyjay - The Name/Email formulas are showing an error "UNPARSEABLE".
-
Can you please send the formula that is on your sheet/cell?
...
-
I believe this may be a duplicate post?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!