Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-06-2012, 04:40 AM
OTPM OTPM is offline Simple Excel sort did not work correctly Windows 7 32bit Simple Excel sort did not work correctly Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default Data Sorting

Hi
Your issue may be something to do with where you got your data from.
You may have "white spaces" at the beginning of your fields etc.
Try copying your data into a Word table first and turn on the "Show/Hide" button. This will show you whether you have strange characters wrapped around your data, which you can then remove before copying it back to Excel.
Hope this helps.
If not and you can post a sample I will take a look for you and advise further.
Good luck.
Tony
Reply With Quote
 

Tags
hidden, sort



Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple Excel sort did not work correctly Is this sort of pivot possible in the Excel? Jamal NUMAN Excel 4 02-14-2012 02:48 PM
Simple Excel sort did not work correctly Excel not entering numbers correctly weety Excel 2 06-29-2011 01:07 AM
simple code doesn't work help piper7971 PowerPoint 2 08-19-2010 08:15 AM
Why wont my simple formulae work? Florish Excel 4 02-17-2009 07:33 AM
Office2003 won't work correctly for non-admin when logged on ob Office 1 08-16-2006 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft