| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
I would like to sort a column of alpha-numeric characters by only the last
seven characters €“ can someone help? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting
Insert a new column next to your data, enter the formula
=RIGHT(A1,7), copy down as far as you need to go, and sort on that column. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sdmccabe" wrote in message ... I would like to sort a column of alpha-numeric characters by only the last seven characters - can someone help? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting
I am missing something, sorry. I data I want to limit to seven characters
starts in column G2. In H2 I entered the formula, =right(h2,7), but it doesn't display the last seven - what did I do wrong? "Chip Pearson" wrote: Insert a new column next to your data, enter the formula =RIGHT(A1,7), copy down as far as you need to go, and sort on that column. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sdmccabe" wrote in message ... I would like to sort a column of alpha-numeric characters by only the last seven characters - can someone help? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting
I meant to say =right(g2,7)
"sdmccabe" wrote: I am missing something, sorry. I data I want to limit to seven characters starts in column G2. In H2 I entered the formula, =right(h2,7), but it doesn't display the last seven - what did I do wrong? "Chip Pearson" wrote: Insert a new column next to your data, enter the formula =RIGHT(A1,7), copy down as far as you need to go, and sort on that column. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sdmccabe" wrote in message ... I would like to sort a column of alpha-numeric characters by only the last seven characters - can someone help? Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting
What does it display?
-- Kevin Vaughn "sdmccabe" wrote: I meant to say =right(g2,7) "sdmccabe" wrote: I am missing something, sorry. I data I want to limit to seven characters starts in column G2. In H2 I entered the formula, =right(h2,7), but it doesn't display the last seven - what did I do wrong? "Chip Pearson" wrote: Insert a new column next to your data, enter the formula =RIGHT(A1,7), copy down as far as you need to go, and sort on that column. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sdmccabe" wrote in message ... I would like to sort a column of alpha-numeric characters by only the last seven characters - can someone help? Thanks. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting
The formula
"Kevin Vaughn" wrote: What does it display? -- Kevin Vaughn "sdmccabe" wrote: I meant to say =right(g2,7) "sdmccabe" wrote: I am missing something, sorry. I data I want to limit to seven characters starts in column G2. In H2 I entered the formula, =right(h2,7), but it doesn't display the last seven - what did I do wrong? "Chip Pearson" wrote: Insert a new column next to your data, enter the formula =RIGHT(A1,7), copy down as far as you need to go, and sort on that column. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sdmccabe" wrote in message ... I would like to sort a column of alpha-numeric characters by only the last seven characters - can someone help? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
| Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
| sorting number in ascending order | Excel Discussion (Misc queries) | |||
| Adding a KeyID column for sorting | New Users to Excel | |||
Hybrid Mode
