Aaagghhhhhhhhhh - Just saw your other post and sat there thinking 'Why would
Harlan use all that just to get rid of an initial letter?"
.......................... then I read the damn question
properly!!!!!!!!!!!!!!!!

Didn't see the bit where the first letter got converted to something else
:-(

( Going back to bed now I think - Will try getting up again <g )

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

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

"Ken Wright" wrote in message
...
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 ?