Thread: Remove a - from text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Allen Mark Allen is offline
external usenet poster
  
Posts: 54
Default Remove a - from text
Is it possible to create a formula to remove a - from a cell??

Example:

A needs to be B
445-2134 4452134
er-6978 er6978
7777-99987 77799987

Hope you can help me please!!

Regards

Mark
Reply With QuoteReply With Quote