Splitting Cells

[confusedryan]

Does anyone know how to split the data in my cells
Currently it looks like this.

1 - 2 - 3,4,5
A - B - C


I would like it to look like this.
1 - 2 - 3
1 - 2 - 4
1 - 2 - 5
A - B - C

Can anyone help me please?

[ranman256]

This code looks for commas only between characters...if your text sometimes has commas and sometimes not, then you need to alter the code below...

Please Login or Register  to view this content.

[confusedryan]

Is there a way to do this without code?

[XOR LX]

Perhaps, but I for one can't work out from your diagram which entries are in which cells - can you clarify?

Regards

[confusedryan]

Currently,
Cell A1 = 1
Cell A2 = 2
Cell A3 = 3,4,5
Cell B1 = A
Cell B2 = B
Cell B3 = C

I would like it to read,
Cell A1 = 1
Cell A2 = 2
Cell A3 = 3
Cell B1 = 1
Cell B2 = 2
Cell B3 = 4
Cell C1 = 1
Cell C2 = 2
Cell C3 = 5
Cell D1 = A
Cell D2 = B
Cell D3 = C

Thank you.

[XOR LX]

Thanks.

Perhaps your desired results could be achieved by placing them in cells different to those containing the original data, though since you are wanting the actual cell contents to overwrite themselves then you will certainly need VBA.

Regards

[confusedryan]

Okay, Thank you for your help.