I assume your second ABCD should read BCDA.

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Jonny JetSet" <Jonny wrote in message
...
Please Help!!!

I would like to use a spreadsheet to program a 'roll' of text.

Examples: ABCD to roll to BCDA and ABCD to roll toCDAB.

I am using Microsoft Office 2003 - Excel 2003.