Hey folks,
I'm trying to determine if the last character of a cell is a number or not a number. So in a cell I may have a string like:
ZXC123
or
ZXC123A
If the last character is not a number I want the letter returned. So I thought I could use a formula like:
=IF(NOT(ISNUMBER(RIGHT(D88,1))), RIGHT(D88,1),"")
However for the string ZXC123 it still returns '3' so anyone have any ideas how I can do this?
Last edited by chergh; 10-23-2008 at 10:43 AM.
And I've just answered my own questions looking at a previous post.
=IF(NOT(ISNUMBER(--RIGHT(D88,1))), RIGHT(D88,1),"")
Seems to do the job.
The RIGHT function will return a string, so you need to convert it to numeric. Try this:
=IF(NOT(ISNUMBER(VALUE(RIGHT(D88,1)))), RIGHT(D88,1),"")
HTH
Jason
Looks like you answered your own question before I could!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks