How to sort column

  • Thread starter Thread starter abid
  • Start date Start date
A

abid

Hi everybody,
I am sure somebody must have posted the answer for this
question earlier.

I am having difficulty of sorting one column in my
spreadsheet. I have numeric data in that colum like
numbers 1-100 and then other data like 1-a, 1-b and 2-a 2-
c. I want to sort it like first cell it should show me 1
and then next cell 1-a and 1-b and 2 then 2-a and 2-b.
But
I am sorting it, data is coming like this first 1-100
numbers and then starting again with 1-a and 1-b but I
want that to be 1 and 1-a. I changed that colum to text
but still not working.
Pls help me with this.
Thanks in advance
abid
 
My excel sheet look like this
45
55
6
7
3
2
89
1-a
1-c
45-d
67-c
I want to sort it like this
1-a
1-c
2
3
6
7
Pls help how to do it?
thanks
 
Changing the cell format won't change the data type. To sort your data, I
suggest something like the following:

With your data in A1:A100:

B1: =A1&""

Fill down to B100. Then copy B1:B100 and Paste Special as "Values" into
B1:B100.

Now sort just B1:B100. You'll get a prompt asking you what to do with
numeric values. Choose the radio button that tells XL to treat all of your
values as text.

/i.
 
Hello abid,

In order to have a spreadsheet sort data, the first row
(known as field heading row) should always have a format
applied to it. ie: bottom border usually works well.

Once all your data is entered beneath each row heading
(down each column) then this data set is defined as a
database. To sort your data, click on Data Sort, then
choose the feild heading you wish to sort. You may sort
up to three sorts only.

There are some general rules to understand about sorting.
To see the order of data and how it's sorted. In a new
workbook place any heading name in cell A1, (Sort) Be
sure to apply a bottom border to this cell. Then beneath
this column A2:A15 ?? start entering sample data you might
use such as:
Sort
1
1-a
1-A
-1-a
-a-1

Then while still anywhere while in this column, click
Data, Sort, be sure to leave in ascending order. Try
different cell formats for your data, (text, number,
general, percentage) to see the results of your sample
data and how it sorts.


Hope this helps
Paul
 
Back
Top