Left and Find Formula Issue

Andy S.

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

Andy S.

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)

Andy S.

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)

Genevieve P.

Thanks for posting your solution! 🙂