removing part of a #

[Linny51]

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?

 

[Dave R.]

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","")

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?