I have numerical data with alphabetical prefixes in a column.
This is what I get when I sort:
C1,C10,C2,C8,R1,R10,R11,R2
This is what I want when I sort:
C1,C2,C8,C10,R1,R2,R10,R11.
How can I do this?
I have numerical data with alphabetical prefixes in a column.
This is what I get when I sort:
C1,C10,C2,C8,R1,R10,R11,R2
This is what I want when I sort:
C1,C2,C8,C10,R1,R2,R10,R11.
How can I do this?
You need to extract the numbers into ahelp column and sort by the help
column, if indeed you only have a letter in the string you can use
=--RIGHT(A1,LEN(A1)-1)
copy down, select both columns and sort by the help column
--
Regards,
Peo Sjoblom
"Brad" <[email protected]> wrote in message
news:[email protected]...
> I have numerical data with alphabetical prefixes in a column.
>
> This is what I get when I sort:
> C1,C10,C2,C8,R1,R10,R11,R2
>
> This is what I want when I sort:
> C1,C2,C8,C10,R1,R2,R10,R11.
>
> How can I do this?
Hi Brad,
I guess Peo meant if you only have the same letter in front
of each cell. Some additional suggestions might be found in
http://www.mvps.org/dmcritchie/excel/sorttcp.htm
When asking a question you want to include a representation
of what you would actually be working with.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Peo Sjoblom" <[email protected]> wrote in message news:[email protected]...
> You need to extract the numbers into ahelp column and sort by the help
> column, if indeed you only have a letter in the string you can use
>
> =--RIGHT(A1,LEN(A1)-1)
>
> copy down, select both columns and sort by the help column
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "Brad" <[email protected]> wrote in message
> news:[email protected]...
> > I have numerical data with alphabetical prefixes in a column.
> >
> > This is what I get when I sort:
> > C1,C10,C2,C8,R1,R10,R11,R2
> >
> > This is what I want when I sort:
> > C1,C2,C8,C10,R1,R2,R10,R11.
> >
> > How can I do this?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks