S
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Elkar
That formula should work. Does your data in G2 have spaces at the end perhaps?
C
Chip Pearson
What is displayed in H2? What is in cell G2?
S
sdmccabe
No, no spaces at the end of the data - any other suggestions?
S
sdmccabe
G2
JS1CK43A862101040
H2 (the formula)
=right(G2,7)
JS1CK43A862101040
H2 (the formula)
=right(G2,7)
P
Pete_UK
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
=RIGHT(TRIM(G2),7)
Copy down, highlight all the columns you want sorted and sort on column
H.
Hope this helps.
Pete
P
Pete_UK
Ensure that H2 is not formatted as text - you should see 2101040 in
there.
Pete
there.
Pete
E
Elkar
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
If so, the cell is probably formatted as text. Change the Cell Format to
General.
HTH,
Elkar
D
Dave Peterson
Format H2 as General (format|cells|Number tab)
Then with H2 still selected, hit F2 and then enter.
Then with H2 still selected, hit F2 and then enter.