Hi Rednelle,

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Rednelle" wrote in message
...
Greetings all,

I'm new and inexperienced.


My problem - to unconcatenate - to split a string into its leftmost
character and the remainder (which may be nothing).

I guess I can strip the leftmost alpha/numeric character from the string
using the LEFT function.

What is the best expression for my remainder?

Thanks in advance,

Rednelle