Thread: remove some but not all internal spaces
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JDUK JDUK is offline
external usenet poster
  
Posts: 3
Default remove some but not all internal spaces
I have several hundred cells of postcode sector data in a column from which I
need to remove the first internal space but not the second. Is there an
automatic way to do this?
eg "SL 1 1" needs to be "SL1 1"
Reply With QuoteReply With Quote