Thread: remove unwanted spaces?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nige Danton Nige Danton is offline
external usenet poster
  
Posts: 13
Default remove unwanted spaces?
On Dec 7, 5:23 pm, "Arvi Laanemets" wrote:
Select the range with data, from where you want remove ALL spaces.
Search 'Find what' - enter " " , 'Replace with' - remains empty Replace
All

Bingo! Thanks everybody.

--
Nige Danton
Reply With QuoteReply With Quote