Alphabetizing Help

1. The four entries that I listed are, for exercise purposes, in Cells A1:A4 (each name is entered in its own single cell)

2. The output (properly alphabetized list) will, say, appear in Cells B1:B4

I hope this makes it clearer. Thanks again.

Originally Posted by Richard Buttrey

Hi,

Can you clarify. Do you literally mean that all the text you show is in a single cell. I presume you mean that each of the four lines you showed are in 4 cells, e.g. A1:A4.

What's stopping you clicking anwhere in A1:A4 and then choosing SORT from the menu?

Regards

Just to repeat, why not sort them? Data > Sort, ...