+ Reply to Thread
Results 1 to 1 of 1

Write the numbers into one cell

  1. #1
    Registered User
    Join Date
    03-23-2010
    Location
    Melbourne Australia Down Under
    MS-Off Ver
    Excel 2010
    Posts
    56

    Smile Write the numbers into one cell

    Hi

    Further to my earlier post concerning missing numbers and to the great help provided by zbor.

    This the last post received and it works.


    Write this formula in E10:

    =IF(COLUMNS($E$10:E$10)<$C11-$C10,$C10+COLUMNS($E$10:E$10),"")

    And pull it right and down as much as you need.

    Notice that for example:

    9154100
    9154251

    you need to go at least 151 column to the right...

    Maximum is 256
    The above function writes the missing numbers in a new column.

    I have a further question.

    Is it possible to write the numbers into one cell so that I can then text wrap instead of

    you need to go at least 151 column to the right...
    Last edited by kapeller; 02-12-2011 at 05:34 AM.
    Have a great day!!!!

    Lou

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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