Excel question...

Discussion in 'Software' started by Roystacy, Sep 12, 2007.

  1. Roystacy

    Roystacy Private First Class

    Does anyone know a quick answer on how to make Excel sort by the first letter or number only in a cell? Like I need it to sort A through Z before hitting AA, BB, CC.... Thanks.
     
    Roystacy, Sep 12, 2007
    #1
  2. bigbazza

    bigbazza R.I.P. 14/12/2011 - Good Onya Geek

    Maybe make a new single cell (with a single letter or number in it) and make that your first sort item? Bazza

    ===

     
    bigbazza, Sep 12, 2007
    #2
  3. usafveteran

    usafveteran MajorGeek

    That would be done with the Left function. For example, if cell A1 contains AA, you could generate A in cell B1 by entering =LEFT(A1,1) in B1. Be sure to include this extra column in all sorts so that the formula cells remain in the same row of the cell to which they refer.
     
    usafveteran, Sep 13, 2007
    #3
  4. bigbazza

    bigbazza R.I.P. 14/12/2011 - Good Onya Geek

    Thanks for the better explanation. I knew what I meant, but maybe no-one else did. :eek: :D Bazza

    ===

     
    bigbazza, Sep 13, 2007
    #4

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds