+ Reply to Thread
Results 1 to 6 of 6

removing punctuation macro

  1. 03-04-2020, 02:12 PM #1
    dorabajji
    dorabajji is offline
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    486

    removing punctuation macro

    Is there any macro.. to remove ;/, in the words in the cell
    I have total 2000 row words
    Reply With QuoteRegister To Reply
  2. 03-04-2020, 02:27 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: removing punctuation macro

    Hi

    Have you tried the standard Find & Replace functionality.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 03-04-2020, 02:38 PM #3
    dorabajji
    dorabajji is offline
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    486

    Re: removing punctuation macro

    i want a macro.. yes.. i did.. but it is giving incorrect..
    Reply With QuoteRegister To Reply
  4. 03-04-2020, 02:55 PM #4
    BMV
    BMV is offline
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: removing punctuation macro

    Quote Originally Posted by dorabajji View Post
    i want a macro.. yes.. i did.. but it is giving incorrect..
    Then the example of your data is necessary.
    Reply With QuoteRegister To Reply
  5. 03-04-2020, 04:55 PM #5
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: removing punctuation macro

    As BMV says, please upload your workbook.
    Reply With QuoteRegister To Reply
  6. 03-04-2020, 06:18 PM #6
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,692

    Re: removing punctuation macro

    "in the words in the cell" means to me that you have multiple words in a cell separated by a space and that each word might have one of these characters.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Changing and adding punctuation in a split macro?
    By dark91zc in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-02-2013, 05:09 PM
  2. Single macro for spell check, highlighting duplicate word and highlighting end punctuation
    By Athi123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-06-2013, 12:13 AM
  3. Single macro for spell check, highlighting duplicate word and highlighting end punctuation
    By Athi123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 07:51 AM
  4. Macro to highlight cells which have content with an end punctuation
    By Athi123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-31-2013, 03:04 AM
  5. Removing punctuation from a string
    By hazzacanary in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2012, 10:29 PM
  6. Removing punctuation in a formula
    By williscm in forum Excel General
    Replies: 2
    Last Post: 06-18-2009, 12:30 AM
  7. Removing Punctuation
    By silvertt in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-25-2007, 06:43 AM
  8. Remove all punctuation.
    By Dr.Jamescook in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1