Results 1 to 9 of 9

Thread: Macro To Delete Numbers With Trailing Character

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    add this line
    Code:
    .ClearFormats
    after line
    Code:
    On Error Resume Next
    Note: Clear Formats under Home > Clear will remove the trailing apostrophe
    Last edited by Admin; 04-05-2013 at 04:27 PM.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Replies: 9
    Last Post: 05-22-2013, 09:12 PM
  2. Macro to delete trailing X's
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 03-29-2013, 12:43 PM
  3. Display numbers in Lakhs
    By Prabhu in forum Excel Help
    Replies: 3
    Last Post: 04-11-2012, 10:19 AM
  4. Count words having more than one character in a cell
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 3
    Last Post: 03-13-2012, 08:29 PM
  5. Average Of The X Largest Numbers
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-16-2011, 04:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •