+ Reply to Thread
Results 1 to 3 of 3

Make entire column limit character size and delete extras

  1. 02-02-2015, 02:25 PM #1
    OldLadyStillLearning is offline
    Registered User
    Join Date
    02-02-2015
    Location
    Arizona
    MS-Off Ver
    2013
    Posts
    14

    Make entire column limit character size and delete extras

    Hi All,

    I have a macro that does everything I need except limit character size and delete extra characters. I need to apply this limit to an entire column but I am dumb as a rock when it comes to writing code in Macros. Can some one help me please?
    Reply With QuoteRegister To Reply
  2. 02-02-2015, 02:42 PM #2
    xlbiznes is offline
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Make entire column limit character size and delete extras

    you can use left or right function to get rid of extra characters.

    Assuming A1 holds Welcome to Excel Forum and you need only starting 7 characters then you can write the code as :

    Please Login or Register  to view this content.
    the output would be Welcome
    if you need the last 5 characters only then :
    Please Login or Register  to view this content.
    the output would be Forum
    Last edited by xlbiznes; 02-02-2015 at 02:44 PM.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *
    Reply With QuoteRegister To Reply
  3. 02-02-2015, 02:42 PM #3
    xlbiznes is offline
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Make entire column limit character size and delete extras

    Sorry , the post got duplicated.
    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] How to make Font Size auto adjust to the Number of Character inside the cell?
    By jp16 in forum Excel General
    Replies: 2
    Last Post: 01-16-2013, 03:42 AM
  2. [SOLVED] Conditional formatting of a cell in a column if character count reaches a limit
    By Pavan Renjal in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 01-13-2013, 03:16 PM
  3. Count how many dups-delete the extras-remove Rev at the end
    By legeorgia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-24-2012, 07:15 PM
  4. Trying to Limit Character and Delete Characters that are Over the Limit
    By cmenard in forum Excel General
    Replies: 1
    Last Post: 01-13-2011, 02:29 PM
  5. Add a alphabetic character to the beginning of an entire column of
    By Karise in forum Excel General
    Replies: 1
    Last Post: 08-18-2005, 06: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1