| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when i sort, how can i get the formatting to sort along with text | Excel Worksheet Functions | |||
| Sort text list by character length - how? | Excel Worksheet Functions | |||
| Sort text list alphabetically using a formula | Excel Worksheet Functions | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
Linear Mode
