Results 1 to 6 of 6

Insert a line break (CHAR(10)) after every 42 characters

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    1

    Insert a line break (CHAR(10)) after every 42 characters

    Hi All,

    I need a formula to insert a line break after every 42 characters in a cell , example if there is 266 characters in a cell there should be 6(266/42)line breaks.

    =REPLACE(REPLACE(A1,42,0,CHAR(10)),84,0,CHAR(10))

    I tried this but i am not sure how to get the start num to change to 126,168 and so on

    Any help is highly appreciated

    Thanks
    Last edited by Rajkiran557; 06-21-2014 at 08:17 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-16-2013, 03:58 PM
  2. Automatic Line Break at X number of characters
    By duyane in forum Excel General
    Replies: 3
    Last Post: 07-17-2012, 02:12 AM
  3. Replies: 5
    Last Post: 10-19-2011, 12:27 PM
  4. [SOLVED] How to break up a cell with 3 embedded (new line characters) value
    By Phil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2005, 07:05 PM
  5. insert &char(10) after 100 characters
    By murphyz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2005, 05:57 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1