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" wrote in message
...
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?