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
Help Article Resources
Check out the Formula Handbook template!