Sort Mulple Values alphabetically within a Cell seperated by a comma, whole worksheet

**pszpeti** · 05-27-2015, 02:54 AM

Hi! I am writing my thesis and i have a bunch of data from my questionnaire (double letter columns, 800+ rows). In some of my cells there are many words separated by commas. I need to be able to sort the words alphabetically within the cells. I found lesoies' macro here http://www.excelforum.com/showthread...1993&p=4083788
and i applied kalak's fix for it. Now it works in column A until row 5. I figured out how to make it work in any number of rows, but I can't seem to solve the problem of making it work outside column A. Colud you please help me?

**YasserKhalil** · 05-27-2015, 03:26 AM

Hi pszpeti
It's so easy
In this line

Please Login or Register  to view this content.

1 represent row 1 as starting row and 5 represents row 5 as the end row

and in this line

Please Login or Register  to view this content.

1 stands for column A so it can be any column you desire
for example if you need column G , just change 1 to 7 or even type "G" with quotes instead of 1
hope it will help

**pszpeti** · 05-27-2015, 03:53 AM

OMG thank you! It's so easy, I'm ashamed

)

**YasserKhalil** · 05-27-2015, 03:58 AM

You're welcome

**sbrie6** · 10-07-2015, 06:14 PM

Whist running the script, I ran into "Runtime Error '9' - Subscript out of range" prompt.

This was due to a group of empty rows...

Can anything be done via the script, to overcome this error???

Also, it removes the 'space' after each 'comma'...can the script be changed to add that, rather than using the 'find & replace' function after each script run?

Sort Mulple Values alphabetically within a Cell seperated by a comma, whole worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Sort Mulple Values alphabetically within a Cell seperated by a comma, whole worksheet

Re: Sort Mulple Values alphabetically within a Cell seperated by a comma, whole worksheet

Re: Sort Mulple Values alphabetically within a Cell seperated by a comma, whole worksheet

Re: Sort Mulple Values alphabetically within a Cell seperated by a comma, whole worksheet

Re: Sort Mulple Values alphabetically within a Cell seperated by a comma, whole worksheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Sort Mulple Values alphabetically within a Cell seperated by a comma

[SOLVED] Unique values from comma seperated text to different worksheet

Sum of comma seperated values in cell(Reposting)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions