excelismagic
asked on
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","Nu meric") but it does not work.
Column A
564654/AJJDNFD
8789788/5654554
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),
Column A
564654/AJJDNFD
8789788/5654554
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER