Thread: Replace dashes
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default Replace dashes

Thank soooo much.

"Dave F" wrote:

=SUBSTITUTE(A1,"-","")

Dave
--
Brevity is the soul of wit.


"Wanna Learn" wrote:

Hello
I have a column of numbers example 12-2222-02 . I need to delete the dashes.
the number should read 12222202 What is the fastest way to do this thanks