Thanks. Do I copy and paste special, as instructed in Ken's previous email?
Also, do I choose A) Sort anything that looks like a number as a number, or
B) Sort numbers and numbers stored as text seperately? I'm a real novice.
Thanks for your help.
"Bryan Hessey" wrote:
>
> Try
>
> =IF(ISERROR(FIND("-",A1)),TEXT(A1,"000000"),TEXT(LEFT(A1,(FIND("-",A1)-1)),"000000")&MID(A1,(FIND("-",A1)),99))
>
> where "000000" needs to be long enough to cover your largest number,
> and all alpha addons need to be after a '-' character.
>
> V-ger Wrote:
> > Still not sorting correctly. What am I doing wrong? It's better, but
> > the 3
> > still comes after the 22-A. Two issues...first, does the cell format
> > need to
> > be "General" or "Number" or what? Second, when I type the formula you
> > wrote
> > below it didn't work, but when I copied it from your post and pasted it
> > in,
> > it worked as a formula - is it equals, quote, quote, ampersand,
> > cell-address-of-the-cell-to-the-left? Thank you so much!
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=485021
>
>
Bookmarks