+ Reply to Thread
Results 1 to 3 of 3

Parse text in cell, on fixed width

  1. #1
    Registered User
    Join Date
    12-22-2009
    Location
    Chattanooga
    MS-Off Ver
    Excel 2007
    Posts
    19

    Parse text in cell, on fixed width

    I have text in Column C. I need to make Column C fixed width at 28.14. The text that runs over I need to put in Column D (broken up by the whole word). On the rare chance that Column D runs over, I need it put in to Column E. That will be the last one needed. All 3 columns will be fixed width at 28.14.

    I've searched and searched but cannot make code I find work. I'm not that great at programming so please help.

    Thanks!

    Attached is an example sheet that needs the macro.
    Attached Files Attached Files
    Last edited by HMM; 12-10-2010 at 04:26 PM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Parse text in cell, on fixed width

    Hi

    See how this goes.
    Please Login or Register  to view this content.
    rylo

  3. #3
    Registered User
    Join Date
    12-22-2009
    Location
    Chattanooga
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Parse text in cell, on fixed width

    Thanks! I had to make a minor modification to my other code to make it work. Since it will be used by more than one person and everyone has their font preferences, I used this to set it up before it split everything. With a little tweaking of the cell width it is perfect!

    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)

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