General discussion
March 18, 2004 at 02:08 AM
hunterzh

How to remove first three digits quickly

by hunterzh . Updated 22 years, 6 months ago

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 discussion is locked

All Comments