Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 53
  • 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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