Results 1 to 14 of 14

Parse cell data into multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2008
    Posts
    29

    Parse cell data into multiple columns

    Hello,

    Can someone pls. assist me in providing me with vba code (or formulas) that can parse data from individual cells into multiple columns? I have attached a file noting the current inputs in columns A-F and the desired outputs in columns I-O. Additionally, I have noted the distinguishing criteria for each of the fields in cells I13-O13. Also, I noticed that each of the data points in the input cells are separated by at least two spaces. Hopefully, this will help in building the code. Lastly, the input data in the working sheet goes from columns A-H and the desired outputs would start from column I; with row 1 having the headers.

    Thank you in advance.
    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. Parse data from one cell to multiple cells
    By Shiraz.dobby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2014, 12:45 AM
  2. [SOLVED] Parse Data from file and assign to columns on another worksheet looping multiple records
    By Streaker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-07-2013, 12:02 AM
  3. How do I parse a single column of data into multiple columns?
    By stevenica in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-02-2011, 02:27 PM
  4. Parse Text, Split to New Row, Multiple Columns
    By msbaker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2010, 02:01 PM
  5. Parse data from one cell to multiple cells
    By cchoo13 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-11-2009, 01:40 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