split the cell data into column

[sundarmanik]

I have data in excel i want to split cell value into column. please help on this

Cell A i have part name cell B i have assembly name

i have data LIKE THIS IN EXCEL

trail-5018645001 QC4200,QC4806
trail-5018804001 QC3419,QC3420,QC5007
trail-5018804001 QC3510,QC3520,QC4308,QC4315,QC4410,QC4411,QC4414,QC4455
trail-5018994001 QC3702,QC3703,QC3704,QC3705,QC3708,QC3709,QC3710,QC3711
trail-5018244001 QC3608,QC4556,QC4557,QC4559,QC4560
trail-5018544001 QC4316,QC4317,QC4566,QC4567


i WANT LIKE THIS

trail-5018645001 QC4200
trail-5018645001 QC4806
trail-5018804001 QC3419
trail-5018804001 QC3420
trail-5018804001 QC5007

[oeldere]

use text to column with the seperator ,

after that you can delete the column B - Z.

Another option is

b1 =

Please Login or Register  to view this content.

and drag down

[sundarmanik]

hi,

thank u for reply
But my input is like this
trail-5018576001 12 R4309,R4310,R4314,R4400,R4457,R4458,R4459,R4460,R4461,R4462,R4463,R4464


I want output like this

trail-5018576001 R4309
trail-5018576001 R4310
trail-5018576001 R4314
trail-5018576001 R4400
trail-5018576001 R4457
trail-5018576001 R4458
trail-5018576001 R4459
trail-5018576001 R4460
trail-5018576001 R4461
trail-5018576001 R4462
trail-5018576001 R4463
trail-5018576001 R4464

we have input more that 1000 its difficult every time doing this

[oeldere]

b1 =

Please Login or Register  to view this content.

[sundarmanik]

i am not got it

can u give me macro for this

[Richard Buttrey]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your original thread.

Thread Closed.