+ Reply to Thread
Results 1 to 3 of 3

Excel: Seperating Words from a Cell to Multiple Rows

  1. #1
    Registered User
    Join Date
    10-02-2010
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    7

    Excel: Seperating Words from a Cell to Multiple Rows

    Hi everyone,

    Let's jump directly to the question:
    Assume I have cell A1 with values
    A1 = ABAB CDEDF FGHI JKLMNO
    (the length of each words could vary, but the number of words will not exceed 8)

    I want to break (make a copy of) them to cell A2, A3, A4, ...
    So we get:
    A1 = ABAB CDEDF FGHI JKLMNO
    A2 = ABAB
    A3 = CDEDF
    A4 = FGHI
    A5 = JKLMNO

    How's the VBA code?
    Thanks for your help.
    Last edited by 4Ferdinand; 12-16-2010 at 08:55 AM.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Excel: Seperating Words from a Cell to Multiple Rows

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-02-2010
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Excel: Seperating Words from a Cell to Multiple Rows

    Thank you so much.
    It works.

+ 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