removing part of a #

I have a large list of numbers all starting with "20", i.e., 20-12-473. I
want to remove the "20" from all the #'s. Is there a quick way of doing that?

You can do a find/replace (ctrl-H) with find= 20 or 20-
and "replace with" left blank.

Or with a formula, you could use =substitute(a1,"20","")


"Linny51" <[email protected]> wrote in message
news:[email protected]...
> I have a large list of numbers all starting with "20", i.e., 20-12-473. I
> want to remove the "20" from all the #'s. Is there a quick way of doing
that?