Hi all,
I am using this formula to return a number that's left of the "x". This formula would return a 2 but formatted as text. How can I get the same result formatted as a number?
=IFERROR(LEFT(N41,SEARCH("x",N41)-1),"")
Thank you!
Russ
I am using this formula to return a number that's left of the "x". This formula would return a 2 but formatted as text. How can I get the same result formatted as a number?
=IFERROR(LEFT(N41,SEARCH("x",N41)-1),"")
Thank you!
Russ