Returning numbers separated by commas

[ToadOnRoll]

Hello All,

I have columns which have numbers separated by comma. E.g.

3,135,234
123,23,456,765
23,2345

etc. etc.

Does anyone know how I can return the numbers into separate cells? So one cell for the first number, next cell for 2nd number and so on. Obviously some codes have more than 2 sets of numbers and each set of numbers is made up of a different amount of integers.

I'd rathee use a simple formulae, but is this something a macro could do for me?

Thankyou

ToadOnRoll

 

[Peter_SSs]

ToadOnRoll, did you find an answer to this issue that you can share with me? Would be much obliged if you could share it with me.

Welcome to the MrExcel board!

What happens if you try the Text to Columns suggested earlier in the thread?

Alternatively, since you have version 365 and assuming the values are Text and not Numerical you could try this

23 09 12.xlsm
	A	B	C	D	E
1	3,135,234	3	135	234
2	123,23,456,795	123	23	456	795
3	23,2345	23	2345
Split Commas

Cell Formulas
Range	Formula
B1:D1,B3:C3,B2:E2	B1	=TEXTSPLIT(A1,",")
Dynamic array formulas.