+ Reply to Thread
Results 1 to 3 of 3

Create new cell with character count

  1. #1
    Registered User
    Join Date
    12-29-2013
    Location
    Park City Utah
    MS-Off Ver
    Excel 2010
    Posts
    1

    Create new cell with character count

    I am trying to figure out how to make excel create a new cell after 600 characters and to take all characters from 601 and on and put into a new cell.
    Anyone know if this is possible?
    Thanks

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Create new cell with character count

    With characters in A1, in B1 enter:

    =MID(A1,601,9999)
    Gary's Student

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Create new cell with character count

    You will need a macro.

    I assume you are inputting the data manually. I will address that first.

    The marco will need to be sheet specific. [ right click on the sheet name at the bottom of excel and select view code ]

    It will need to use the worksheet change event. [ Select Worksheet on the left hand list box and worksheet_change on the right hand list box ].

    The macro will simple look at the length of the text in the target cell and if the length is > 600 it will select a cell offset below the target cell and carry on inputting data there.

    Thats it.

    This would be the code:-

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 12-29-2013 at 06:57 PM.

+ 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. character count in a cell
    By raphiduani in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-08-2013, 12:20 AM
  2. Display Active Character Count + Limit Character Per Cell
    By euronail in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2011, 04:59 AM
  3. Character count in a cell
    By estrella921 in forum Excel General
    Replies: 4
    Last Post: 11-20-2007, 11:59 AM
  4. Active Cell Character Count
    By JoJo in forum Excel General
    Replies: 2
    Last Post: 04-16-2007, 07:03 PM
  5. [SOLVED] How do i count character in cell?
    By Angie in forum Excel General
    Replies: 2
    Last Post: 02-21-2005, 07:06 PM

Tags for this Thread

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