View Single Post
  #2   Report Post  
Dave R.
 
Posts: n/a
Default

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?