Hi
I have cells containing data in a list i.e. delimited with a carriage return not a comma, how do i amend the formula in the post http://www.excelforum.com/excel-gene...-new-post.html to cater for this and alphabetically arrange the data back into a list within the cell? At the moment I have a list of text values in each cell each consisting of 5 characters e.g. B0690 the solution on this post gives me an unsorted concatination e.g. B0690B0720B0760B0830B0837B0955B1058B0625 and I need a list (one beneath the other) of alphabetically sorted values.
thanks
Mike
Bookmarks