Prev: looping excel macros
Next: Repost of previous question
From: marcus on 4 Jan 2010 21:17
Hi Roger

This should do what you wish, provided there is one character at the
end of your string as text as you had in your example. If there are
more you may need something else.

=IF(ISNUMBER(VALUE((MID(A1,1,LEN(A1)-1)))),1,0)

Take care

Marcus
 | 
Pages: 1
Prev: looping excel macros
Next: Repost of previous question