| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort, relisted
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(G2,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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Threaded Mode
