wiredemc12
asked on
Left function in excel
I am trying use the left function in excel to pull a numeric value from a cell that reads “26th % ile.” When using the left function, it returns “26”. If I do an if statement the condition is false it does not equal 26. Is excel looking at it as if is a character not a number? How can I trim the first two numeric values?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
test.xlsx