Thread: Replace dashes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Replace dashes

=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