| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort, relisted
That formula should work. Does your data in G2 have spaces at the end perhaps?
"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(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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort, relisted
What is displayed in H2? What is in cell G2?
"sdmccabe" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort, relisted
No, no spaces at the end of the data - any other suggestions?
"Elkar" wrote: That formula should work. Does your data in G2 have spaces at the end perhaps? "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(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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort, relisted
G2
JS1CK43A862101040 H2 (the formula) =right(G2,7) "Chip Pearson" wrote: What is displayed in H2? What is in cell G2? "sdmccabe" wrote in message ... 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort, relisted
Try this amendment to the formula to get the last 7 characters:
=RIGHT(TRIM(G2),7) Copy down, highlight all the columns you want sorted and sort on column H. Hope this helps. Pete |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort, relisted
Ensure that H2 is not formatted as text - you should see 2101040 in
there. Pete |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort, relisted
So, H2 just displays the formula you typed "=right(G2,7)"?
If so, the cell is probably formatted as text. Change the Cell Format to General. HTH, Elkar "sdmccabe" wrote: G2 JS1CK43A862101040 H2 (the formula) =right(G2,7) "Chip Pearson" wrote: What is displayed in H2? What is in cell G2? "sdmccabe" wrote in message ... 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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort, relisted
Format H2 as General (format|cells|Number tab)
Then with H2 still selected, hit F2 and then enter. sdmccabe wrote: G2 JS1CK43A862101040 H2 (the formula) =right(G2,7) "Chip Pearson" wrote: What is displayed in H2? What is in cell G2? "sdmccabe" wrote in message ... 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. -- Dave Peterson |
| Reply |
| 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) | |||
Linear Mode
