Thread: How can I delete a space/character from a number of fields?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jef Gorbach[_2_] Jef Gorbach[_2_] is offline
external usenet poster
  
Posts: 65
Default How can I delete a space/character from a number of fields?
or if you're looking for a code snippet -


Cells.Replace What:="-", Replacement:="", LookAt:=xlPart, SearchOrder
_
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
Reply With QuoteReply With Quote