Thread: more character 160 leading/trailing find/replace problems
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default more character 160 leading/trailing find/replace problems
On Thu, 30 Oct 2008 19:47:02 -0700, M wrote:

Ron !!!!!!
IT WORKED !!!! I was "given up" - simple solution
THANK YOU !!
M

"Ron Rosenfeld" wrote:

=--SUBSTITUTE(A1,CHAR(160),"")
--ron


You're welcome. Glad to help. Thanks for the feedback.
--ron
Reply With QuoteReply With Quote