+ Reply to Thread
Results 1 to 4 of 4

find and replace special characters

  1. #1
    Forum Contributor
    Join Date
    07-30-2012
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    118

    find and replace special characters

    Hi Friends

    I have the below code but it does not find the special character and replace it.

    can anyone help please.

    Please Login or Register  to view this content.
    Thanks in advance.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: find and replace special characters

    Which part is not working?

    As far as I know, you will face problems with "*" and "?" characters. You have to add the "~" character to specifically search for them.

    So in your array, change "*" and "?" to "~*" and "~?".

    Not sure if there are any other problems in there.
    多么想要告诉你 我好喜欢你

  3. #3
    Forum Contributor
    Join Date
    07-30-2012
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    118

    Re: find and replace special characters

    Quote Originally Posted by millz View Post
    Which part is not working?

    As far as I know, you will face problems with "*" and "?" characters. You have to add the "~" character to specifically search for them.

    So in your array, change "*" and "?" to "~*" and "~?".

    Not sure if there are any other problems in there.



    Thanks for responding. But there is a problem in the code that it doesnt find all the special characters in a particular column instead it just replaces only top 2 rows. also it deletes everything in one of the top rows. please suggest a code correction. The for loop for Replacing is not working. It just replaces only top two rows.
    Last edited by irfanparbatani; 09-15-2015 at 12:22 AM.

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: find and replace special characters

    Was having a rather busy day yesterday, hence the slow response.

    Also, I usually avoid naming my subs the same as some built-in function names, just in case any clashes happen.

    Try this:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Replace special characters with Space
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2014, 11:38 AM
  2. VBA to replace special characters with line break
    By saranyabi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 03:11 PM
  3. [SOLVED] Find and replace special characters (unicode)
    By joevan1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2013, 06:05 AM
  4. Macro to replace European characters with non "special" English characters?
    By johanna0507 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2012, 09:13 AM
  5. search and replace special characters
    By jmhultin in forum Excel General
    Replies: 2
    Last Post: 10-14-2009, 12:07 PM
  6. Replies: 1
    Last Post: 05-25-2006, 11:29 AM
  7. [SOLVED] How do I find replace special characters?
    By zzapper in forum Excel General
    Replies: 1
    Last Post: 06-27-2005, 02:05 PM

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