View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TonyL TonyL is offline
external usenet poster
 
Posts: 17
Default Replace non printable characters

I have a column that has a series of non printable characters, mainly the
sqaure character. I want to replace them with a space. I tried the CLEAN
function but it replaces the characters with nothing & therefore joins words
together. TIA
--
Tony