+ Reply to Thread
Results 1 to 3 of 3

Split Text on word boundary

  1. #1
    Registered User
    Join Date
    02-25-2008
    Posts
    2

    Split Text on word boundary

    Hi,

    I tried searching split text and text to columns, but didn't really find the answer, so I hope I'm asking something original and not something that's been explained a thousand times

    I have a column of cells where each cell is a textual description of upto 60 to 80 characters. I need to split these single cells into multiple cells with a max length of 20 characters(5 cells max). The extra need and the reason that fixed length of text to columns didn't work for me is that the split must be on a word boundary. So for example:

    A1 = This is a test of the emergency broadcast system

    would give

    B1 = This is a test of
    C1 = the emergency
    D1 = broadcast system

    It'd be great if leading spaces would be eliminated on the new cell (but not necessary). It doesn't need to be an auto macro as this is more or less a one time deal of several hundred records.

    Any suggestions?

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523
    RobertMee,

    This udf by Wim Gielis should do the trick.

    HTH

    Robert

  3. #3
    Registered User
    Join Date
    02-25-2008
    Posts
    2
    Quote Originally Posted by Trebor76
    RobertMee,

    This udf by Wim Gielis should do the trick.

    HTH

    Robert
    Thanks!! That appears perfect. Now to learn how to use it

    EDIT: You da man. That was easy and absolutely perfect. Applause!
    Last edited by robertmee; 02-26-2008 at 10:53 AM.

+ 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