Count number of chars or digits in a cell? Parse out last char?

  • Thread starter Thread starter RF
  • Start date Start date
R

RF

Is it possible to count the number of numbers or letters
in a cell? And is it possible to test the
characters/numbers in a cell to see if something in
position x is a number or a letter?

I am trying to parse out the last character of a cell if
it is a letter. I have cell entries like:
ColA Colb
15 (blank)
014r r
4 (blank)
07a a

and I want to create a formula (colb) which populates a
cell with only the letter in the last position of data in
cola, if a letter exists.

Thanks,
RF
 
Hi
try the following formula in B1
IF(ISNUMBER(--RIGHT(A1,1)),"",RIGHT(A1,1))
and copy down
 
Thanks! That does the trick. Where did you find the "--"
for the Right function? That doesnt appear in help.

Thanks,
RF
 
Hi
its just a 'double minus'. This converts the text to a number. You
could also use
1*RIGHT(..)
or
0+RIGHT(...)
 
Back
Top