Forum Discussion
Getting copy/paste into excel to populate vertically
Sorry but I don't understand the question. Can you send your file to me in a private message? Click on my avatar and select Message.
- Thank you for your reply. I have made a PDF document with screen shots to show you what is going on and uploaded it to my OneDrive at this link:
https://1drv.ms/b/c/080681367835d8cc/EUP6AAnIpbtAoQscLUA7qVABgCbWd0DZQwBi9cpwmOw_hg?e=ARAUl6
Here is the text of the PDF:
I had almost 6,000 names in a word document and all the names were separated by a comma.
I copied all the names into line number 1 of my excel document – which put them on a horizonal line. I followed your instructions on how to make them appear vertically so each name would have a number, instead of having a letter of the alphabet (along the horizontal line).
MY NEW EXCEL PROBLEM:
After moving the names along the numbered, vertical lines I have added some names and deleted duplicates during the last week. I just noticed they are all not sorting as one group.
For some reason, I now have two groups of names – the original very long list of names and the new, smaller batch of names. I try to “sort” them by highlighting the long list of names and they will not merge.
The total number of names on the list is 5,925 and the last name at that number is Xavier.
The original list of names ends with Zuckerberg at number 5841 and the new names starts with Al Pacino at 5842.
On the very first line where I originally had copied all the list of names from Word, I saw this little arrow and I clicked it to see what it was and it had all the names from the original list (ending with Zuckerberg) and not the new addition of names. So I think this is why it is not sorting the new names. Somehow, the new names need to be on this list for it to sort all of them alphabetically?
How do I get all these names to be one list, in alphabetical order?I think they are in alphabetical order. Look closely at the end of the original data:
Notice how "Al Pacino" starts a little further left than "Zuckerberg"? It appears that your original names all came with a leading space character. And spaces sort before any alphabetics/digits.
To make them consistent, you could (manually or by formula) add a leading space before all the new names. Or, more likely, you can remove the leading spaces (and any trailing spaces) from all names, as described next.
Save a backup copy before you try the following. I do not have a Mac, but this should work. (I'll assume that column B is currently not used. If it is in use, just substitute with some other unused column further to the right.)
In cell B1, put the formula
=TRIM(A1)Copy that formula all the way to the last row (5925). So column B should now show the values you want, i.e., without leading (or trailing) spaces.
Select B1:B5925. Copy it (you can press Cmd+C or use a menu).
To overwrite the current values in column A, select cell A1, right click it, and choose Paste Values. The values are overwritten.
You can then delete column B.
(And then sort the data.)
- I can not download your file because of network.
I think it may easier to understand your request if you provide some foke datas in text instead of screenshot and desired output based on the source table.
