Recent content by ClickSystems

Hi Josef, In 30 years, I've never found a use for a non-breaking space whether at the start, in the middle or at the end of a string, so for my use I'm happy to remove them wherever they appear. Others should amend the code to suit their needs. Thanks 👍

Hi, The post was about trimming a string so I was only dealing with regular and non-breaking spaces at the beginning or end of a string, but the replace would take care of the non-breaking spaces where ever they appeared in the string, if you wanted to get rid of all spaces in the string then...

The Trim takes care of chr(32)

What benefit would this give?

Hi, I know this is an old post but I recently came across the same issue and using gblacks code as a base used the following two line solution which trims the text and then the replace removes the Non-breaking spaces. Public Function True_Trim(strText As String) As String On Error GoTo...