View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RichardSchollar[_2_] RichardSchollar[_2_] is offline
external usenet poster
 
Posts: 76
Default how to remove dashes

On 28 Feb, 05:28,
wrote:
I have a list of 500 part number with dashes in between. Example 1234-56-789.
How do able to remove the dashes to make it 123456789?


You could do them en masse by using Find/Replace ie select the entire
column and press Ctrl+H and in Find What: - and in Replce With:
(leave this blank).

Hope this helps!

Richard