How to move multiple numbers in once cell to its own cell.

Question

Hey guys I want to see if there's a way to move these multiple numbers below to its own cell, without copying and pasting each one.

Contract(s)
96762930, 97219149
92576717, 96595747, 97729782
92448591, 96739578
99682021
99681126
99680276
99678414
99677024

Answer 1

Hi,

Enter this formula in cell D2.

=TRIM(TEXTSPLIT(TEXTJOIN(",",, TOCOL(A2:A20, 1)),, ","))

HTH

Ilir

Answer 2

text to column and choose comma,

If you are using M365,

=TEXTSPLIT(A2,",")

Answer 3

Will that add the extra numbers on the bottom of the same column?

Answer 4

You may use another formula to put it into same column. Another way is to use power query.

=TOCOL(B2:D9,1)

1. Split column with ", "

2.Select all the column and unpivot column

3. Result

Answer 5

Hi,

Question answered here - How to move multiple numbers from one cell to is own cell on the same - Microsoft Community