I have data in cell A1 that looks like this. I want to be able to
seperate it with the left right mid functions into B1,C1, D1, E1, F1,
and get rid of the comma's. Any help would be greatly appreciated.

25632, 27865, 456456, 987456, 789456

thanks Glenn

It would be easier to use Data | Text to Columns | delimited by a comma and
space. It wouldn't matter then how long the numeric strings were.

It looks as though you have spaces in there too. Assuming there a

B1 =MID(A1,1,5)
C1 =MID(A1,8,5)
D1 =MID(A1,15,6)
E1 =MID(A1,23,6)
F1 =MID(A1,31,6)

If there are no spaces, adjust the start positions.

You don't need to use LEFT and/or RIGHT

Regards

Trevor


"QTGlennM" wrote in message
oups.com...
I have data in cell A1 that looks like this. I want to be able to
seperate it with the left right mid functions into B1,C1, D1, E1, F1,
and get rid of the comma's. Any help would be greatly appreciated.

25632, 27865, 456456, 987456, 789456

thanks Glenn

one way

Sub test()
arr = Split(Trim(Range("a1")), ",")
Range("b1:f1").Value = arr
End Sub


Gary


"QTGlennM" wrote in message
oups.com...
I have data in cell A1 that looks like this. I want to be able to
seperate it with the left right mid functions into B1,C1, D1, E1, F1,
and get rid of the comma's. Any help would be greatly appreciated.

25632, 27865, 456456, 987456, 789456

thanks Glenn