software

I would like to sort a column of alpha-numeric characters by only the last
seven characters – can someone help? Thanks.

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.comquot;sdmccabequot; gt; wrote in message
...
gt;I would like to sort a column of alpha-numeric characters by
gt;only the last
gt; seven characters - can someone help? Thanks.
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?

quot;Chip Pearsonquot; wrote:

gt; Insert a new column next to your data, enter the formula
gt; =RIGHT(A1,7), copy down as far as you need to go, and sort on
gt; that column.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;sdmccabequot; gt; wrote in message
gt; ...
gt; gt;I would like to sort a column of alpha-numeric characters by
gt; gt;only the last
gt; gt; seven characters - can someone help? Thanks.
gt;
gt;
gt;

I meant to say =right(g2,7)

quot;sdmccabequot; wrote:

gt; I am missing something, sorry. I data I want to limit to seven characters
gt; starts in column G2. In H2 I entered the formula, =right(h2,7), but it
gt; doesn't display the last seven - what did I do wrong?
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt; gt; Insert a new column next to your data, enter the formula
gt; gt; =RIGHT(A1,7), copy down as far as you need to go, and sort on
gt; gt; that column.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Cordially,
gt; gt; Chip Pearson
gt; gt; Microsoft MVP - Excel
gt; gt; Pearson Software Consulting, LLC
gt; gt; www.cpearson.com
gt; gt;
gt; gt;
gt; gt; quot;sdmccabequot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I would like to sort a column of alpha-numeric characters by
gt; gt; gt;only the last
gt; gt; gt; seven characters - can someone help? Thanks.
gt; gt;
gt; gt;
gt; gt;

What does it display?
--
Kevin Vaughnquot;sdmccabequot; wrote:

gt; I meant to say =right(g2,7)
gt;
gt; quot;sdmccabequot; wrote:
gt;
gt; gt; I am missing something, sorry. I data I want to limit to seven characters
gt; gt; starts in column G2. In H2 I entered the formula, =right(h2,7), but it
gt; gt; doesn't display the last seven - what did I do wrong?
gt; gt;
gt; gt; quot;Chip Pearsonquot; wrote:
gt; gt;
gt; gt; gt; Insert a new column next to your data, enter the formula
gt; gt; gt; =RIGHT(A1,7), copy down as far as you need to go, and sort on
gt; gt; gt; that column.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Cordially,
gt; gt; gt; Chip Pearson
gt; gt; gt; Microsoft MVP - Excel
gt; gt; gt; Pearson Software Consulting, LLC
gt; gt; gt; www.cpearson.com
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;sdmccabequot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt;I would like to sort a column of alpha-numeric characters by
gt; gt; gt; gt;only the last
gt; gt; gt; gt; seven characters - can someone help? Thanks.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;

The formula

quot;Kevin Vaughnquot; wrote:

gt; What does it display?
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;sdmccabequot; wrote:
gt;
gt; gt; I meant to say =right(g2,7)
gt; gt;
gt; gt; quot;sdmccabequot; wrote:
gt; gt;
gt; gt; gt; I am missing something, sorry. I data I want to limit to seven characters
gt; gt; gt; starts in column G2. In H2 I entered the formula, =right(h2,7), but it
gt; gt; gt; doesn't display the last seven - what did I do wrong?
gt; gt; gt;
gt; gt; gt; quot;Chip Pearsonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Insert a new column next to your data, enter the formula
gt; gt; gt; gt; =RIGHT(A1,7), copy down as far as you need to go, and sort on
gt; gt; gt; gt; that column.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Cordially,
gt; gt; gt; gt; Chip Pearson
gt; gt; gt; gt; Microsoft MVP - Excel
gt; gt; gt; gt; Pearson Software Consulting, LLC
gt; gt; gt; gt; www.cpearson.com
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;sdmccabequot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt;I would like to sort a column of alpha-numeric characters by
gt; gt; gt; gt; gt;only the last
gt; gt; gt; gt; gt; seven characters - can someone help? Thanks.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;

Ensure that the cell is formatted for General, not Text.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;sdmccabequot; gt; wrote in message
...
gt; The formula
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt;gt; What does it display?
gt;gt; --
gt;gt; Kevin Vaughn
gt;gt;
gt;gt;
gt;gt; quot;sdmccabequot; wrote:
gt;gt;
gt;gt; gt; I meant to say =right(g2,7)
gt;gt; gt;
gt;gt; gt; quot;sdmccabequot; wrote:
gt;gt; gt;
gt;gt; gt; gt; I am missing something, sorry. I data I want to limit to
gt;gt; gt; gt; seven characters
gt;gt; gt; gt; starts in column G2. In H2 I entered the formula,
gt;gt; gt; gt; =right(h2,7), but it
gt;gt; gt; gt; doesn't display the last seven - what did I do wrong?
gt;gt; gt; gt;
gt;gt; gt; gt; quot;Chip Pearsonquot; wrote:
gt;gt; gt; gt;
gt;gt; gt; gt; gt; Insert a new column next to your data, enter the formula
gt;gt; gt; gt; gt; =RIGHT(A1,7), copy down as far as you need to go, and
gt;gt; gt; gt; gt; sort on
gt;gt; gt; gt; gt; that column.
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; --
gt;gt; gt; gt; gt; Cordially,
gt;gt; gt; gt; gt; Chip Pearson
gt;gt; gt; gt; gt; Microsoft MVP - Excel
gt;gt; gt; gt; gt; Pearson Software Consulting, LLC
gt;gt; gt; gt; gt; www.cpearson.com
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; quot;sdmccabequot; gt; wrote in
gt;gt; gt; gt; gt; message
gt;gt; gt; gt; gt; ...
gt;gt; gt; gt; gt; gt;I would like to sort a column of alpha-numeric
gt;gt; gt; gt; gt; gt;characters by
gt;gt; gt; gt; gt; gt;only the last
gt;gt; gt; gt; gt; gt; seven characters - can someone help? Thanks.
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;
We seem to have cross-posting here. I suggested in the other thread
that you should ensure H2 is not formatted as text - click H2, Format |
Cells | Number (tab) then select General. Then double click the cell as
if to edit and press lt;entergt; - you should see the final 7 digits. Then
copy down and sort.

Hope this helps.

Pete