Results 1 to 6 of 6

Find/Replace Characters in a string

Threaded View

Light Pail Find/Replace Characters in a... 01-20-2010, 07:02 PM
quekbc Re: Find/Replace Characters... 01-20-2010, 07:36 PM
shg Re: Find/Replace Characters... 01-20-2010, 07:49 PM
Light Pail Re: Find/Replace Characters... 01-20-2010, 07:52 PM
shg Re: Find/Replace Characters... 01-20-2010, 08:06 PM
quekbc Re: Find/Replace Characters... 01-20-2010, 08:08 PM
  1. #1
    Registered User
    Join Date
    01-14-2010
    Location
    Portland, OR USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Find/Replace Characters in a string

    There is a string "strSearch" which contains characters "&lte;". I would like to replace "&lte;" with "≤", but for some reason it is replaced with "=". The function below works otherwise...the character code is correct. What is the problem here?

    Public Function ReplaceinString(strSearch As Variant)
       If IsNull(strSearch) Then
          ReplaceinString = ""
       Else
          ReplaceinString = Replace(strSearch, "&lte;", ChrW(8804))
          MsgBox (ChrW(8804))
       End If
        
    End Function
    Last edited by Light Pail; 01-20-2010 at 07:12 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1