View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Removing Hyphen(s)

Highlight the cells and use Find & Replace (CTRL-H) - Find hyphen and
replace with nothing.

Hope this helps.

Pete

On Mar 10, 2:49*pm, Curtis wrote:
I have numbers separated by Hyphen(s) and I am looking for an easy way to
remove the Hyphen and just leave the text

My data could be

1410-4031 or 1469-1555-043

Thanks

--
ce