Thread: Unwanted Square Character in .txt file
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Unwanted Square Character in .txt file
That is probably a better choice.

--
Regards,
Tom Ogilvy



"BrianB " wrote in message
...
There is a worksheet function called CLEAN() that may help.
This removes any characters that are not printable.

eg =CLEAN(A1)


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote