General discussion

Locked

How to remove first three digits quickly

By Hunterzh ·
In Excel2000, there is one column with coding number, like 10.B100250; with around 2000 rows; now I hope to remove first three digits from all cells in this column, 10.B100250 then changes to B100250
How can I do this by a function or macro?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to How to remove first three ...

If all of the numbers are in column A, put this formula in an empty column and fill to the bottom:
If the number is fixed at 7 digits:
=RIGHT(A1,7)
If the number could go over 7 significant digets:
=RIGHT(A1,LEN(A1)-3)

Collapse -

by Hunterzh In reply to

Poster rated this answer.

Collapse -

by Hunterzh In reply to How to remove first three ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums