+ Reply to Thread
Results 1 to 2 of 2

VBA - Extract Words from Text String

  1. #1
    Registered User
    Join Date
    01-11-2007
    Posts
    94

    VBA - Extract Words from Text String

    Hello All,

    Need help, is this doable?

    In Sheet1 ; Column G ; Data starts in G2 ; G column head "Description" ; 86000+ rows in sheet 1

    I have text string of variable lengths in Column G, I want to split each word from text string and put them into columns P to Z+ onwards. I do not believe it would exceed columns in excel

    Thank you.
    NKRA

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: VBA - Extract Words from Text String

    Maybe copy Column G to Column P and then do a Text-to-Columns on Column P?

+ 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. Extract n words from string
    By holmes123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-07-2012, 10:29 PM
  2. Extract a string of text between certain words
    By delboy2405 in forum Excel General
    Replies: 3
    Last Post: 01-17-2012, 12:40 AM
  3. UDF to extract first three words from string
    By stodge in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2011, 07:25 AM
  4. Extract last two words from string
    By dimid in forum Excel General
    Replies: 5
    Last Post: 11-28-2008, 11:07 PM
  5. Extract repeated words from Text string
    By Calman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-14-2007, 10:22 PM

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