simple formula but cannot get it work.

the following is example of the data i have

i want to do a logical test to check whether the last 5 chars of cell string is numeric or text.

i do this =IF(ISTEXT(RIGHT(A2,5)+0),"Text","Numeric")  but it does not work.  


Column A
564654/AJJDNFD
8789788/5654554
LVL 3
excelismagicAsked:
Who is Participating?
 
ProfessorJimJamConnect With a Mentor Commented:
=IF(NOT(ISNUMBER(--RIGHT(A2,5))),"Text","Numeric")
0
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try
=IF(ISNUMBER(RIGHT(A2,5)+0),"Numeric","Text")

Open in new window

Regards
0
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Another one....
=IF(ISERROR(RIGHT(A2,5)+0),"Text","Numeric")

Open in new window

0
 
Brian BConnect With a Mentor EE Topic Advisor, Independant Technology ProfessionalCommented:
The formulae above all seem to work. The issue was your proposed formula didn't allow for the fact that adding a number to text produces a #value error. So applying that to your formula, any time your LEFT()+0 function should have returned text, you got an error, which is not text. Thus ISTEXT() returned FALSE and thus you IF() function returned "numeric".
0
 
excelismagicAuthor Commented:
thank you all.
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.

All Courses

From novice to tech pro — start learning today.