View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Tim Millar Tim Millar is offline
external usenet poster
 
Posts: 1
Default Removing select text from a cell

I have a cell formatted for Text with the following information;

006-0527-5475

I want to remove just the huphens so it looks like this;

00605275475

Does anyone have the formula or process I can use? I have about 3000+ cells
I need to modify this way.

Thank you.