You could Paste the first sheet to the second sheet then convert text to
columns and choose a fixed width.

or

or in cell a1 use the left(Sheet1!a1, 4) function
in cell b1 use mid(sheet1!b1,a1,5,255) function

then copy both formulas down

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=519336