Hi I have Data in the following format
Cell A1 contains 3508 and cell B1 contains a list of data as mentioned below
80007384
80007394
80007392
I want this data in the cell B1 to be split into 3 different cells C1 C2 and C3 each containing
80007384 and 80007394 and 80007392 respectively.
the data in cell B1 could vary it could have 5 ,6 or any number of numbers.
Thank you so much in advance.
Bookmarks