• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 54
  • Last Modified:

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
0
excelismagic
Asked:
excelismagic
4 Solutions
 
ProfessorJimJamCommented:
=IF(NOT(ISNUMBER(--RIGHT(A2,5))),"Text","Numeric")
0
 
Rgonzo1971Commented:
Hi,

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

Open in new window

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

Open in new window

0
 
Brian BIndependant 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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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