Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Confused on the tundra
 
Posts: n/a
Default Sorting imported "numbers"

I've imported a long list of "numbers" from a server. Now in my excel table I
can not sort them. I've tried multiplying the col. by "1" from paste special,
Add from a free cell and paste special, using a macro form the converting
text to number page, using trim and clean function, copy and paste as value,
using the text to columns command, all to no avail. The "numbers" still stay
left justified and sort by first number, i.e. 113 before 21 etc.

There are 1500 entries and I do no think the table woudl be of much use
after i tried to re-type in all the numbers. The three numbers I did have to
enter do work fine, and sort above all the other "numbers" . I have several
columns that have "numbers" in them and woudl like to be able to sort, at
varoius time, by any one.
  #6   Report Post  
confused on the tundra
 
Posts: n/a
Default

I did the trim function. I finally fixed it by doing a "save as" a csv.
(comma delimited text file) I opened that file in notepad and did a find and
replace of all the spaces after the numbers, e.g. changed ,410339 ,xxx, to
,410339,xxx,. This changed all the text/numbers to real numbers and it sorted
fine after I opened the csv file in excel. I saved it as a excel fiel and now
all is well. I am sure there are easier ways to do this.

"CLR" wrote:

Maybe you have a leading space in front of each number...............try

TRIM(a1)

Vaya con Dios,
Chuck, CABGx3


"Confused on the tundra" <Confused on the
wrote in message ...
I've imported a long list of "numbers" from a server. Now in my excel

table I
can not sort them. I've tried multiplying the col. by "1" from paste

special,
Add from a free cell and paste special, using a macro form the converting
text to number page, using trim and clean function, copy and paste as

value,
using the text to columns command, all to no avail. The "numbers" still

stay
left justified and sort by first number, i.e. 113 before 21 etc.

There are 1500 entries and I do no think the table woudl be of much use
after i tried to re-type in all the numbers. The three numbers I did have

to
enter do work fine, and sort above all the other "numbers" . I have

several
columns that have "numbers" in them and woudl like to be able to sort, at
varoius time, by any one.




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
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 05:55 PM
I enter numbers and they are stored as text burkeville Excel Discussion (Misc queries) 5 December 3rd 04 02:59 AM
sorting question Brian Excel Discussion (Misc queries) 4 November 28th 04 01:30 PM


All times are GMT +1. The time now is 01:35 PM.

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

About Us

"It's about Microsoft Excel"