VBA Macro to spilit Data

[rshnkmr39]

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.

[nilem]

try this in C1

Please Login or Register  to view this content.

and drag to the right

[jindon]

C1:

=TRIM(MID(SUBSTITUTE($B$1,CHAR(10),REPT(" ",LEN($B$1))),LEN($B$1)*ROW(A1)-LEN($B$1)+1,LEN($B$1)))

Then copy down.

[rshnkmr39]

Thank you . This works .