mike:

when you configure the text to columns, all you have to do is select the text
radio button instead of the general button, for the specific column on step 3 of
the wizard, and it should do this for you.

--


Gary Keramidas
Excel 2003


"Mike H" wrote in message
...
Vic,

Just noticed you'll lose the leading zero in C2 so custom format that cell
as 000 to get it back

"Mike H" wrote:

Vic

Data - Text to Columns - Fixed width and set the breaks OK

Mike

"Vic" wrote:

What is the formula to split 10 alphanumerics into 3 cells?
I have A2 = 1067035C03
I need B2 = 1067, C2 = 035, D2 = C03
Thank you.