Split the column to many.....

[upmuthukumar]

Hello all,

Good Morning to all....

I have a doubt in split the column to many like below.

Actual Result
01-610-23456-01 01 610 23456 01
01-610-23457-02 01 610 23457 02
01-610-23458-03 01 610 23458 03
01-610-23459-04 01 610 23459 04

My A column has the actual fields, I need to split the column in to B,C,D and E. I have attached the sample excel FYI...

How to achieve this?

Thanks and Regards,
Muthu

[:) Sixthsense :)]

In B2 cell

=TRIM(MID(SUBSTITUTE("-" & TRIM($A2)& REPT("-",6),"-",REPT(CHAR(32),255)),COLUMNS($B$1:B$1)*255,255))

Drag it down and right...........

[upmuthukumar]

Wow...

Its really awesome, thank you very much for your help

Regards,
Muthu