+ Reply to Thread
Results 1 to 3 of 3

Find & Replace all special characters with regular

  1. #1
    Registered User
    Join Date
    02-21-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    66

    Find & Replace all special characters with regular

    Hi all,

    I've been searching for a code to find & replace all special characters in a range of data with regular alphabet letters.

    For example, find all and replace with O, find all and replace with n, and so on and so on.

    The list isn't confined to the two above, I need to make sure I find all special characters and replace with all regular characters.

    So far the lists I've found are: "" and need to replace with "SZszYAAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy"

    I've found the following function code:
    Please Login or Register  to view this content.
    but 1) i'm not sure how to convert this to a procedure that runs at the click of a button and run through every cell in a range automatically (E:E should do it) to clean and replace with regular characters?

    and 2) being a novice code manipulator if anyone is bored please can you explain the difference between a function & a procedure, and how to run/call the former please?

    Alternatively, I came across this as well but it crashes before even running and with my limited understanding I'm at a loss why?!

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

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    21,905

    Re: Find & Replace all special characters with regular

    An idea.
    1) Place :
    ŠŽšžŸ in A1 or cell available
    SZszYAAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy in A2 or any cell available
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    21,905

    Re: Find & Replace all special characters with regular

    Duplicate post.

+ 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. find and replace special characters
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-15-2015, 09:30 PM
  2. [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
  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. 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