Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 34
  • Last Modified:

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?
0
wiredemc12
Asked:
wiredemc12
1 Solution
 
wiredemc12Author Commented:
file attached
test.xlsx
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Yes, you compare text with a number. Use =Value(Left(A1,2)) in B1.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now