Solved

Left function in excel

Posted on 2016-07-30
2
21 Views
Last Modified: 2016-07-30
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
Comment
Question by:wiredemc12
2 Comments
 

Author Comment

by:wiredemc12
Comment Utility
file attached
test.xlsx
0
 
LVL 68

Accepted Solution

by:
Qlemo earned 500 total points
Comment Utility
Yes, you compare text with a number. Use =Value(Left(A1,2)) in B1.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now