Thread: remove some but not all internal spaces
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default remove some but not all internal spaces
=SUBSTITUTE(D1," ","",1)


"JDUK" wrote:

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