Results 1 to 5 of 5

Extract data from text string

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Extract data from text string

    Hello there, I have attached my example workbook. In cell A1 I have a text string, with a comma separating each entity.

    I would like to extract and stack each entrant as shown in the example. So the name will appear in B and the price in C.

    Could someone help with the formula needed to extract and order in this way from the text string in A1
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract data from text string
    By cmb80 in forum Excel General
    Replies: 14
    Last Post: 07-16-2014, 11:29 AM
  2. [SOLVED] Extract text from a given point in a text string, when data points do not share the given
    By reedersketer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2014, 03:57 PM
  3. Extract data from text string to columns
    By bigband1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2012, 09:12 AM
  4. Extract data from text string
    By bigband1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2011, 04:55 AM
  5. Extract number data string from text
    By lamatao in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2009, 04:27 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