Hi, I have a list contained within 1 single cell (Cell A1), i.e.;
90046
62534
98163
98362
34263
etc.
I want to change it so that the list isn't all in one single cell and even though it'll still be a list, each item on the list will have it's own individual cell i.e.;
90046 (will be in A1)
62534 (will be in B1)
98163 (will be in C1)
98362 (will be in D1)
34263 (will be in E1)
etc.
Is my only option to insert dozens of rows and cut and paste each item on my list into it's own cell?
Thanks in advance!
90046
62534
98163
98362
34263
etc.
I want to change it so that the list isn't all in one single cell and even though it'll still be a list, each item on the list will have it's own individual cell i.e.;
90046 (will be in A1)
62534 (will be in B1)
98163 (will be in C1)
98362 (will be in D1)
34263 (will be in E1)
etc.
Is my only option to insert dozens of rows and cut and paste each item on my list into it's own cell?
Thanks in advance!