Alphabetize words in a cell help

[erikpaulsen]

I got another one for you excel experts out there Your help is greatly appreciated by the way..

I need a solution to alphabetize words in a cell.

For example: Dog Bird Apple Cat
Result: Apple Bird Cat Dog

Thanks in advance you guys!

[Richard Buttrey]

Hi,

Here's a user defined function.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[mehmetcik]

Paste this code into a macro module.

Please Login or Register  to view this content.

Enter your list into a cell eg A1

then type

Please Login or Register  to view this content.

into the cell where you want the sorted list


or try this format instead:-

Please Login or Register  to view this content.

[erikpaulsen]

Thanks you guys for the quick response. Both worked great actually.