Excel Sort Contents of cells
 

Is it posiible and how does one sort cell contents. I have cells with values
c;b;a that need top be sorted A;B;C

Excel Sort Contents of cells
 

Select the cells and use Data | Sort
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bob" wrote in message
...
Is it posiible and how does one sort cell contents. I have cells with
values
c;b;a that need top be sorted A;B;C

Excel Sort Contents of cells
 

That will sort the cloumn but my problem is sorting the content so f the
cells. THe cell contents need to be alpha sorted and they contents is
somewaht random.

Bob

"Bernard Liengme" wrote:

Select the cells and use Data | Sort
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bob" wrote in message
...
Is it posiible and how does one sort cell contents. I have cells with
values
c;b;a that need top be sorted A;B;C

Excel Sort Contents of cells
 

there is no build in support for it - do you want a macro.

I assume you want the original cell to contain the sorted value.

--
Regards,
Tom Ogilvy

"Bob" wrote in message
...
Is it posiible and how does one sort cell contents. I have cells with
values
c;b;a that need top be sorted A;B;C

Excel Sort Contents of cells
 

"Tom Ogilvy" wrote:

there is no build in support for it - do you want a macro.

I assume you want the original cell to contain the sorted value.

--
Regards,
Tom Ogilvy

"Bob" wrote in message
...
Is it posiible and how does one sort cell contents. I have cells with
values
c;b;a that need top be sorted A;B;C