See my other reply

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Lowell Copeland" wrote in message ...

Ron de Bruns solution was only partial. It copied the last three
character into the cell on the right, but it did not remove them from
the original active cell.

Anyone have any ideas.

Lowell



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!