+ Reply to Thread
Results 1 to 4 of 4

VBA to find and replace odd or non-standard characters

  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    VBA to find and replace odd or non-standard characters

    I sometimes find strange characters in text I open in Word. I'll attach a file showing an example of the sort of symbol I mean.

    It often shows itself in random and mysterious sets.

    For example :





    I've tried to search and replace these , but often I get reports of not found , or else Word misinterprets them and deletes different characters entirely.

    Can someone suggest some VBA to run through and delete these unwelcome intruders?

    Grateful for any advice.

    Attached Files Attached Files
    Last edited by CDandVinyl; 08-09-2020 at 09:00 PM.
    Using Excel , Word and Access 2003 - For the whole of 2024

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: VBA to find and replace odd or non-standard characters

    Try this;

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    Re: VBA to find and replace odd or non-standard characters

    Many thanks - this works very well. I'm grateful for your help.


  4. #4
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: VBA to find and replace odd or non-standard characters

    You're welcome...

+ 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 non-standard colors
    By ammartino44 in forum Excel General
    Replies: 4
    Last Post: 03-19-2015, 05:09 PM
  2. [SOLVED] find and replace to not replace characters found as wildcards
    By sabutler4 in forum Excel General
    Replies: 4
    Last Post: 07-03-2013, 06:48 PM
  3. Find and replace characters.
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-04-2012, 02:31 PM
  4. [SOLVED] Find and replace - max characters per row
    By dshilan in forum Excel General
    Replies: 1
    Last Post: 04-03-2012, 03:09 PM
  5. find and replace certain characters
    By imichalopo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2010, 03:08 PM
  6. [SOLVED] FIND and REPLACE characters needed
    By Peter C in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-10-2006, 03:10 PM
  7. Find and Replace Characters
    By lytaylor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2005, 09:03 AM

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