Bob


Using your formulas on this example John A Doe results in John A and
Doe, is it possible to split it to show John / A / Doe in 3 separate
cells

If possible could you explain what the formula is doing, I understand
LEFT and LEN etc but don't understand the use of ^^

Thanks

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=391447