Thread: remove dashs from social security numbers
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default remove dashs from social security numbers
Select the range and use
edit|replace
what: - (that dash)
with: (leave blank)
replace all



Hemi wrote:

is there a way to remove dashs out of the social security number is excel
spreedsheet

--

Dave Peterson
Reply With QuoteReply With Quote