ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   alphabetize (https://www.excelbanter.com/excel-discussion-misc-queries/122393-alphabetize.html)

EC

alphabetize
 
If I have a few words separated by spaces in one cell, is there a way for me
to alphabetize the words in that cell?

Eric

Don Guillett

alphabetize
 
http://tinyurl.com/y8oe9x


--
Don Guillett
SalesAid Software

"EC" wrote in message
...
If I have a few words separated by spaces in one cell, is there a way for
me
to alphabetize the words in that cell?

Eric




EC

alphabetize
 
yes, suppose there were so 30 words or so....

"Don Guillett" wrote:

http://tinyurl.com/y8oe9x


--
Don Guillett
SalesAid Software

"EC" wrote in message
...
If I have a few words separated by spaces in one cell, is there a way for
me
to alphabetize the words in that cell?

Eric





Don Guillett

alphabetize
 
Dunno, Test

--
Don Guillett
SalesAid Software

"EC" wrote in message
...
yes, suppose there were so 30 words or so....

"Don Guillett" wrote:

http://tinyurl.com/y8oe9x


--
Don Guillett
SalesAid Software

"EC" wrote in message
...
If I have a few words separated by spaces in one cell, is there a way
for
me
to alphabetize the words in that cell?

Eric







Gord Dibben

alphabetize
 
Copy/paste the code I posted at that URL Don included and select the cell and
run it.

Wish I could remember who originally posted that SortCell code<g

I tested with 93 words in a cell.


Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 14:18:00 -0800, EC wrote:

yes, suppose there were so 30 words or so....

"Don Guillett" wrote:

http://tinyurl.com/y8oe9x


--
Don Guillett
SalesAid Software

"EC" wrote in message
...
If I have a few words separated by spaces in one cell, is there a way for
me
to alphabetize the words in that cell?

Eric







All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com