Left and Find Formula Issue
Are there any glaring issues with the following formula?
=LEFT([AR - Run 1 Size]@row, FIND("""", [AR - Run 1 Size]@row) - 1)
I'm trying to return the leftmost text that occur before the quotation mark. For example,
Original string: 2" InchFisher399
I want just the number 2
I just get #UNPARSABLE
Best Answer
-
I figured it out. It didn't like looking for the quotation mark, so I changed it to look for the space after the quotation mark and then subtract by 2.
=LEFT([AR - Run 1 Size]@row, FIND(" ", [AR - Run 1 Size]@row) - 2)
Answers
-
I figured it out. It didn't like looking for the quotation mark, so I changed it to look for the space after the quotation mark and then subtract by 2.
=LEFT([AR - Run 1 Size]@row, FIND(" ", [AR - Run 1 Size]@row) - 2)
-
Thanks for posting your solution! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!