Pull part of text from a cell
Hello community. I am trying to pull half of this text so that I just get the left hand side of "╏" from the Manufacturer  Model column
The Manufacturer column is not working:
=LEFT([Manufacturer  Model]@row, LEN([Manufacturer  Model]@row)  FIND("╏", [Manufacturer  Model]@row))
Result = Systimax ╏ 360G21U
The Model column is working:
=RIGHT([Manufacturer  Model]@row, LEN([Manufacturer  Model]@row)  FIND("╏", [Manufacturer  Model]@row))
Where am I going wrong here?
Many thanks in advance!
Best Answer

Try this one:
=LEFT([Manufacturer  Model]@row, FIND("╏", [Manufacturer  Model]@row)  2)
In the formula you posted, you are subtracting the location of your delimiter character (10) from the total length of the cell value (31). The result is 21, so it gives you the first 21 characters from the left. Instead, we just find the location of the delimiter and subtract two to account for the character itself and the space before it.
Answers

Try this one:
=LEFT([Manufacturer  Model]@row, FIND("╏", [Manufacturer  Model]@row)  2)
In the formula you posted, you are subtracting the location of your delimiter character (10) from the total length of the cell value (31). The result is 21, so it gives you the first 21 characters from the left. Instead, we just find the location of the delimiter and subtract two to account for the character itself and the space before it.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!