I usally add 3 auxilary column to the worksheet.. these could be hidden
ofr place and the end of the worksheet in columns IT,IU,IV.

Put these formulas in the columns

IT1 =left(A1,1) 'gets the 1st character
IU1 =mid(A1,2,1) 'gets 2nd character
IV1 =mid(A1,3) 'gets everything after and including the 3rd
character


Then copy the formulas down the 3 columns.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=177129

Microsoft Office Help