Sort a word wrap cell and paste into another cell

[zplugger]

Is there a way to sort a lot of names in word wrap cell and paste the names into multiple cells one name at a time?

[reagan.kha]

There sure is. Use the Text-to-Columns feature and chose delimited and select commas as your divider. That should do it.

[zplugger]

Getting Destination Reference is not valid

[reagan.kha]

My best guess is that Excel will not let you use text to columns to a different sheet. Try it again but select the active sheet as the destination. Then you can copy that over to a new sheet, only way to work around it.

[zplugger]

Not sure this can be done, I want all the names in one column?

[mike7952]

Here's a macro that will work

Please Login or Register  to view this content.

[zplugger]

WoW that is close, but it add a sheet everytime I run it. Can I keep it on a single sheet. When I add it will just go to the next empty cell in row a?

[mike7952]

Try this

Please Login or Register  to view this content.

[zplugger]

Thank You, that is outstanding code work.

[mike7952]

Update to post#8 added trim function. If names had leading or trailing spaces, sort would not work correctly.

Please Login or Register  to view this content.

[zplugger]

Ran into a small problem, on sheet 2 some of the names in yellow will not sort? Remove Diplicates does not see them at all?
Z

[mike7952]

Try this

Please Login or Register  to view this content.

[zplugger]

Thanks Mike, now I'm getting Cast: again. Is this right?

Please Login or Register  to view this content.

[mike7952]

Try the code in post #12

[zplugger]

That did it, works like a champ. Speaking of champs that macro you wrote make you a Champ in my book.
Z