• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 33
  • 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
 
QlemoDeveloperCommented:
Yes, you compare text with a number. Use =Value(Left(A1,2)) in B1.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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