Software

Ask something
Discussion Locked

How to remove first three digits quickly

0 helpful
3 replies

by hunterzh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by dklippert

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)

This discussion is closed to new replies.