combine cells
Select the 2nd list. Press Ctrl+X
Go to end of 1st list. Press Ctrl+V Select entire list, and go to Data-Sort. (Or press the A-Z button on your Main toolbar) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "exceler" wrote: I have 2 lists of names in the same worksheet. I want to alphabatise the two lists into 1 list. |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com