Split 10 alphanumerics into 3 cells
 

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.

Split 10 alphanumerics into 3 cells
 

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.

Split 10 alphanumerics into 3 cells
 

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.

Split 10 alphanumerics into 3 cells
 

Try this...

Use this formula in B2
=TRIM(LEFT(A1,4))

Use this formula in C2
=TRIM(MID(A1,5,3))

Use this formula in D2
=RIGHT(A1,3)

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"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.

Split 10 alphanumerics into 3 cells
 

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.