+ Reply to Thread
Results 1 to 2 of 2

Excel VBA Split Text in Cell wit vbLF for multple Cells

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Excel VBA Split Text in Cell wit vbLF for multple Cells

    I am using the macro below to split text in a cell that text with line feeds in it to separate rows.

    Please Login or Register  to view this content.
    I am trying to modify it to also have an inputbox specify the delimiter when it is not a line feed (sometime a space), but I am only getting back the first value. Any ideas as to what the problem is? Non-working code is as follows:

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: Excel VBA Split Text in Cell wit vbLF for multple Cells

    Disregard..apparently, I Dim'ed the Delimiter incorrectly..Should be
    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)

Similar Threads

  1. Macro to split the text in the cell to different cells ( as per enclosure )
    By mvel_sky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2012, 01:23 PM
  2. Split Excel Cell w/o Text-2-Column?
    By benkmann in forum Excel General
    Replies: 13
    Last Post: 05-12-2008, 06:26 AM
  3. Replies: 1
    Last Post: 05-01-2008, 11:24 AM
  4. split text in one cell into multiple cells without breaking the wo
    By Prashant in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2006, 04:48 AM
  5. [SOLVED] Split Long Text Cell into Two Shorter Cells Without Splitting Word
    By Naomi T in forum Excel General
    Replies: 1
    Last Post: 07-07-2005, 01:49 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