Welcome to the MrExcel forum.
What version of Excel and Windows are you using?
Are you using a PC or a Mac?
What is the worksheet name that contains a list of say 10 names
What is the first cell that contains a list of say 10 names
What is the worksheet name that contains the names in a column of 500 names
What is the first cell that contains the names in a column of 500 names
Where are the results from the above going to be placed?
What are the results to look like?
So that we can get it right the first time:
Can you post a screenshot of the actual raw data worksheet?
And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?
To post your data, you can download and install one of the following two programs:
Installation instructions here:
If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link
to your workbook.