|
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.
|