How can I remove hidden paragraph in data?

I am trying to clean up submitted data in my database to display in an export. There is one character that I do not know to get rid of. It creates a new line break in my text editor and I've attached screenshot of what this character looks like in text editor when I choose show hidden characters. I've already removed the following characters:

            strOtherHelp = Replace(strOtherHelp, Chr(10), " ")
            strOtherHelp = Replace(strOtherHelp, Chr(13), " ")
            strOtherHelp = Replace(strOtherHelp, vbCrLf, " ")
          screenshot of hidden characterScreen-Shot-2011-09-02-at-8.59.2.png
trevorayAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
nmarunConnect With a Mentor Commented:
try Chr(20)

Arun
0
 
madginoCommented:
parse strOtherHelp char by char and display the character and asc(character) and you'll find out the code for the character.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.