reverse order of data in one cell

Hi, I'm new to the forum and really hoping a kind soul out there can help me with a problem that is starting to make me pull my hair out!

I have multiple cells which each contain a series of numbers (although not the same amount of numbers in each one) seperated by line breaks (Alt + enter)

cell A1 looks like

2,221,428
124,596
81,715
73,616
1,157,968
1,257,935
300,953

For each cell I need to reverse the order so that the last number comes first, ie

300,953
1,257,935
1,157,968
73,616
81,715
124,596
2,221,428

There are a large number of cells like this so I'm hoping there is some sort of solution out there....

You can add this code to a module in your workbook:

Please Login or Register  to view this content.

To give you a new function, ReverseList

So if your data was in A1 you could use the formula:

=ReverseList(A1,CHAR(10))

Or add a sub to do a batch of cells in one go:

Please Login or Register  to view this content.

Thanks so much to you all. fantastic!!!

these are all doing the trick.

many, many thanks