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 ╏ 360G2-1U-
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!