Dohhhhhhhhhh - you got me Harlan

=--RIGHT(A1,LEN(A1)-1) was what I meant :-(

Cheers for the catch.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Harlan Grove" wrote in message
...
"Ken Wright" wrote...
Always a single letter and at the start?

=--RIGHT(A1,LEN(A1))
...

?!

How does this differ from =--LEFT(A1,LEN(A1)) or just =--A1 ?