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.

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.

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.

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.

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.

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

Sort, relisted
 

Ensure that H2 is not formatted as text - you should see 2101040 in
there.

Pete

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.

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