Split Text
Can someone assist me?
I need a formula on how to split the text for this below.
Ex.
LOW  VS87  ServiceFS Battery Replacement LeadMEGA MALL1259410
I need a to have a column that would write MEGA MALL only.
Best Answer

Please use the formula I provided. It was intentional for the character "~" to be included.
=MID(Name@row, FIND("~", SUBSTITUTE(Name@row, "", "~", 5)) + 1, FIND("~", SUBSTITUTE(Name@row, "", "~", 6))  1  FIND("~", SUBSTITUTE(Name@row, "", "~", 5)))
Kelly
Answers

Assuming the format of your entire text column is formatted as above, your formula is:
=MID([Your Text Column]@row, FIND("~", SUBSTITUTE([Your Text Column]@row, "", "~", 5)) + 1, FIND("~", SUBSTITUTE([Your Text Column]@row, "", "~", 6))  1  FIND("~", SUBSTITUTE([Your Text Column]@row, "", "~", 5)))
Don't forget you will have to change the name of the [Your Text Column] to your actual column name
Will this work for you?
Kelly

I have #INVALID VALUE
=MID(Name@row, FIND("", SUBSTITUTE(Name@row, "", "", 5)) + 1, FIND("", SUBSTITUTE(Name@row, "", "", 6))  1  FIND("", SUBSTITUTE(Name@row, "", "", 5)))

Please use the formula I provided. It was intentional for the character "~" to be included.
=MID(Name@row, FIND("~", SUBSTITUTE(Name@row, "", "~", 5)) + 1, FIND("~", SUBSTITUTE(Name@row, "", "~", 6))  1  FIND("~", SUBSTITUTE(Name@row, "", "~", 5)))
Kelly
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 215 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!