Sorting
 

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

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.

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.

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.

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.

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.

Sorting
 

Ensure that the cell is formatted for General, not Text.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sdmccabe" wrote in message
...
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.

Sorting
 

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 <enter - you should see the final 7 digits. Then
copy down and sort.

Hope this helps.

Pete