View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Removing dashes from a column

Edit Replace

findwhat -
replace with nothing
--
Gary''s Student - gsnu200765


"Tommy Kramer 9" wrote:

I have a 500+ cell column with 13 digit numbers that look like this.
18-118-22-33-0011 I would like to remove all of the dashes from every cell
in the column but I can't figure out how.