dont know.i want to sort a column which is the result of two added columns
but it is not working ,I dont know why

I thinkits becourse of the formulas

1 way:
select all cells in column with data
click on copy icon
click on arrow in paste icon
select values
all ur formula is gone only values stays - now sort

another way:
select all cells in column with data
click on copy icon
select a emty column
click on arrow in paste icon
select values
now sort new column

Thanks
This is what I have done but it didnt work.

"excelent" wrote:

I thinkits becourse of the formulas

1 way:
select all cells in column with data
click on copy icon
click on arrow in paste icon
select values
all ur formula is gone only values stays - now sort

another way:
select all cells in column with data
click on copy icon
select a emty column
click on arrow in paste icon
select values
now sort new column

thanks
This is what I have done but still it is not working

"excelent" wrote:

I thinkits becourse of the formulas

1 way:
select all cells in column with data
click on copy icon
click on arrow in paste icon
select values
all ur formula is gone only values stays - now sort

another way:
select all cells in column with data
click on copy icon
select a emty column
click on arrow in paste icon
select values
now sort new column

Copy a small selection of your data and paste it into a follow-up posting with
some description of what you want it to look like after sorting.


Gord Dibben MS Excel MVP

On Sun, 13 Aug 2006 00:14:02 -0700, fofomama
wrote:

dont know.i want to sort a column which is the result of two added columns
but it is not working ,I dont know why