+ Reply to Thread
Results 1 to 2 of 2

Replace special characters with Space

  1. #1
    Registered User
    Join Date
    03-11-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2010
    Posts
    97

    Replace special characters with Space

    Hi All

    I am looking a macro which should perform below activities

    I have a lists of suppliers which needs to cleansed....

    1.replace all the special characters with a space
    2.replace Corporation with Corp
    Incorporation with Inc
    Limited with Ltd
    Limited partnership/ltd partnership with LP
    Company with Co
    ASSC/ASSOC with ASSOCIATION/ASSOCIATES (SEARCH SUPPLIER IN GOOGLE FOR THE CORRECT ONE)
    MGNT with MANAGEMENT
    SVCS with SERVICES
    DEPT with DEPARTMENT
    Unltd with UNLIMITED
    Ctr with CENTER
    UNIV with UNIVERSITY
    3. Remove any text, Special characters and numbers after INC,CO, LTD, CORP,LLP, LLC

    The macro should when I select any particular columnů not restricted to column A
    Please find the enclosed excel for your perusal

    Thank you

    Regards
    Kiran Kumar

  2. #2
    Registered User
    Join Date
    03-11-2013
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Replace special characters with Space

    Here is the code...

    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] To find the Special charcter and space of the file names and replace with the underscore
    By laxmanann in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-14-2014, 09:31 AM
  2. [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
  3. 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
  4. search and replace special characters
    By jmhultin in forum Excel General
    Replies: 2
    Last Post: 10-14-2009, 12:07 PM
  5. 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