I'm using the following formula to determine if the 3rd character from the right is a number and return a true/false accordingly
=ISNUMBER(LEFT(RIGHT(A1,3),1))
Thing is it's not working as intended, it always return a false even if the character is a number
What gives?
once you use LEFT it changes it to TEXT
maybe this
Formula:
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Not sure why you're using the left function as well but this should do the job:
=ISNUMBER(VALUE(LEFT(RIGHT(A1,3),1)))
Regards,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
You can alsousethings like:
=ISNUMBER(--LEFT(RIGHT(A1,3),1))
and
=ISNUMBER(LEFT(RIGHT(A1,3),1)+0)
to convert the text values returned by LEFT and RIGHT back into numbers.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks