+ Reply to Thread
Results 1 to 6 of 6

macro to remove text after 250 characters?

  1. #1
    Forum Contributor
    Join Date
    05-07-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    215

    macro to remove text after 250 characters?

    Hello everyone. I am looking for a macro that can go down column AH and deleted any content in the cells that comes after 250 characters.

    For example if AH1 has a paragraph and the cell contains 300 characters. The macro will just delete all content after 250th character.

    The last row in the column will always varry. Some sheets have 29k rows or more, some sheets have 30 rows.

    Appreciate the help!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: macro to remove text after 250 characters?

    How about just a formula?

    =left(a1, 250) and copy down. Then you can copy, paste as values, and delete the orginal column.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    05-07-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    215

    Re: macro to remove text after 250 characters?

    That would not work for what I need it for. It would have to be a macro where it does not have to be done manually. It will be used in a preexisting macro.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: macro to remove text after 250 characters?

    FWIW:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    05-07-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    215

    Re: macro to remove text after 250 characters?

    How would I add a rule to have this macro run for a specific sheet named "test1" ?

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: macro to remove text after 250 characters?

    Maybe:

    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] Remove text between characters
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-13-2015, 11:37 AM
  2. Macro to remove characters preceding text descriptions
    By agent.orange in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2014, 06:32 AM
  3. Replies: 8
    Last Post: 12-17-2012, 05:30 AM
  4. How to Remove Characters from Text..?
    By SubPar in forum Excel General
    Replies: 2
    Last Post: 11-19-2012, 05:44 PM
  5. Remove Characters to the Right of text
    By kmlloyd in forum Excel General
    Replies: 2
    Last Post: 11-24-2011, 03:16 PM
  6. Replies: 1
    Last Post: 04-18-2005, 05:06 PM
  7. Replies: 1
    Last Post: 04-17-2005, 08:10 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