Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to sort a list of text?

I get a list of text under column A, and I would like to sort it, but I
cannot use small, because it is not number.
Does anyone have any suggestions on how to sort text?
Thanks in advance for any suggestions
Eric
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How to sort a list of text?

Sorting a column of text works fine in Excel 2003.

Eric wrote:

I get a list of text under column A, and I would like to sort it, but I
cannot use small, because it is not number.
Does anyone have any suggestions on how to sort text?
Thanks in advance for any suggestions
Eric


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to sort a list of text?

There is a list of text under column A, and I would like to sort the list
into column B rather than sort on column A. Do you have any suggestions on
what kind of function I should use? I cannot use SMALL, because text is not a
number.
Do you have any suggestions?
Thanks in advance for any suggestions
Eric

"Bob I" wrote:

Sorting a column of text works fine in Excel 2003.

Eric wrote:

I get a list of text under column A, and I would like to sort it, but I
cannot use small, because it is not number.
Does anyone have any suggestions on how to sort text?
Thanks in advance for any suggestions
Eric



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default How to sort a list of text?

At the top of your worksheet there are two icons. One has an "A" on top and
a "Z" on the bottom with an arrow pointed downward. The other has a "Z" on
top and an "A" on the bottom. Highlight what you want sorted and then select
one of the two options.

"Eric" wrote:

I get a list of text under column A, and I would like to sort it, but I
cannot use small, because it is not number.
Does anyone have any suggestions on how to sort text?
Thanks in advance for any suggestions
Eric

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to sort a list of text?

Thank everyone very much for any suggestions
The text under column A is raw data, and I don't want to touch it.
Based on a list of text under column A, I would like to sort it and list
them out under column B.
Does anyone have any suggestions?
Thank everyone very much for any suggestions
Eric

"REJesser" wrote:

At the top of your worksheet there are two icons. One has an "A" on top and
a "Z" on the bottom with an arrow pointed downward. The other has a "Z" on
top and an "A" on the bottom. Highlight what you want sorted and then select
one of the two options.

"Eric" wrote:

I get a list of text under column A, and I would like to sort it, but I
cannot use small, because it is not number.
Does anyone have any suggestions on how to sort text?
Thanks in advance for any suggestions
Eric



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How to sort a list of text?

Select column A, copy it and paste it into Column B. Select column B
only and Click Data, Sort.

Eric wrote:

Thank everyone very much for any suggestions
The text under column A is raw data, and I don't want to touch it.
Based on a list of text under column A, I would like to sort it and list
them out under column B.
Does anyone have any suggestions?
Thank everyone very much for any suggestions
Eric

"REJesser" wrote:


At the top of your worksheet there are two icons. One has an "A" on top and
a "Z" on the bottom with an arrow pointed downward. The other has a "Z" on
top and an "A" on the bottom. Highlight what you want sorted and then select
one of the two options.

"Eric" wrote:


I get a list of text under column A, and I would like to sort it, but I
cannot use small, because it is not number.
Does anyone have any suggestions on how to sort text?
Thanks in advance for any suggestions
Eric


  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to sort a list of text?

No, that is not what I want to do, I would like to use any function or coding
to do the sorting.
Does anyone have any suggestions?
Eric

"Bob I" wrote:

Select column A, copy it and paste it into Column B. Select column B
only and Click Data, Sort.

Eric wrote:

Thank everyone very much for any suggestions
The text under column A is raw data, and I don't want to touch it.
Based on a list of text under column A, I would like to sort it and list
them out under column B.
Does anyone have any suggestions?
Thank everyone very much for any suggestions
Eric

"REJesser" wrote:


At the top of your worksheet there are two icons. One has an "A" on top and
a "Z" on the bottom with an arrow pointed downward. The other has a "Z" on
top and an "A" on the bottom. Highlight what you want sorted and then select
one of the two options.

"Eric" wrote:


I get a list of text under column A, and I would like to sort it, but I
cannot use small, because it is not number.
Does anyone have any suggestions on how to sort text?
Thanks in advance for any suggestions
Eric



  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How to sort a list of text?

Then record a macro, that would be "coding".

Eric wrote:

No, that is not what I want to do, I would like to use any function or coding
to do the sorting.
Does anyone have any suggestions?
Eric

"Bob I" wrote:


Select column A, copy it and paste it into Column B. Select column B
only and Click Data, Sort.

Eric wrote:


Thank everyone very much for any suggestions
The text under column A is raw data, and I don't want to touch it.
Based on a list of text under column A, I would like to sort it and list
them out under column B.
Does anyone have any suggestions?
Thank everyone very much for any suggestions
Eric

"REJesser" wrote:



At the top of your worksheet there are two icons. One has an "A" on top and
a "Z" on the bottom with an arrow pointed downward. The other has a "Z" on
top and an "A" on the bottom. Highlight what you want sorted and then select
one of the two options.

"Eric" wrote:



I get a list of text under column A, and I would like to sort it, but I
cannot use small, because it is not number.
Does anyone have any suggestions on how to sort text?
Thanks in advance for any suggestions
Eric




  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How to sort a list of text?

Sub copy_sort()
With ActiveSheet
.Range("B:B").Value = Range("A:A").Value
End With
Columns("B:B").Select
Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("B1").Select
End Sub

Note: assumes you have a header row.

If not, change B2 to B1


Gord Dibben MS Excel MVP

On Wed, 14 May 2008 08:32:01 -0700, Eric wrote:

No, that is not what I want to do, I would like to use any function or coding
to do the sorting.
Does anyone have any suggestions?
Eric

"Bob I" wrote:

Select column A, copy it and paste it into Column B. Select column B
only and Click Data, Sort.

Eric wrote:

Thank everyone very much for any suggestions
The text under column A is raw data, and I don't want to touch it.
Based on a list of text under column A, I would like to sort it and list
them out under column B.
Does anyone have any suggestions?
Thank everyone very much for any suggestions
Eric

"REJesser" wrote:


At the top of your worksheet there are two icons. One has an "A" on top and
a "Z" on the bottom with an arrow pointed downward. The other has a "Z" on
top and an "A" on the bottom. Highlight what you want sorted and then select
one of the two options.

"Eric" wrote:


I get a list of text under column A, and I would like to sort it, but I
cannot use small, because it is not number.
Does anyone have any suggestions on how to sort text?
Thanks in advance for any suggestions
Eric




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
when i sort, how can i get the formatting to sort along with text PJ Excel Worksheet Functions 2 September 12th 06 01:03 PM
Sort text list by character length - how? masterdiablo13 Excel Worksheet Functions 2 July 16th 06 07:45 PM
Sort text list alphabetically using a formula paddyyates Excel Worksheet Functions 3 December 21st 05 03:12 AM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM
sort list of players by team from player list on separate sheet Robert Excel Worksheet Functions 1 July 19th 05 01:57 AM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"