Getting only partial text sort in Column (2003 excel)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a 260+ line 8 column worksheet containing text.

Text has been obtained from other spreadsheets forwarded by other sources.

We cleared formatting, and pasted the content into our "consolidated"
spreadsheet

We want to do an alpha sort on Column A

Data -> sort

But the sorrt ends up providing 2 A-Z alpha lists, instead of 1 full alpha
A-z list.

any ideas on how to correct this?
 
Does one of the two lists contain only numbers? If so, you may have some
numbers formatted as text, while some are numbers. If that's the case,
either make all number into real numbers, or change all numbers into text
format as well.

-Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text sort in pivot table 2
sort by two columns ends up with wrong sort in 2nd col 3
vlookup text in vba 3
Finding Duplicates in a Column (Without Sorting) 3
Is there a way to sort text by frequency within Excel? 1
First Value in Sorted Column is Not Sorted Properly 3
How do I sort in Excel alphabetically? 2
Pivot Table Data Column Sort Excel 2007 1

Back
Top