Results 1 to 3 of 3

simple code that extracts several items from middle of cell

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    simple code that extracts several items from middle of cell

    I have data that consist of several pages, each line will load into an excel single cell, however each line has 15 or more pieces of information that has to be extracted to a single cell.
    Is there a simple VB code to do this? Each info piece is separated by a space.
    I am using MO 2013 on Windows 7

    an example line in Cell A1;
    04/15 06/15 14021 GAS R M 0.00427652 2.60 6.60 SEV6 0.34 6.26 06/29/15 1093385 1745
    04/15 should extract to cell B1
    06/15 should extract to cel C1
    etc through P1
    Then the code should loop to repeat for line 2 which is in cell A2, extracting to row 2
    until encountering a blank row then end
    Last edited by l_eonandr; 01-12-2016 at 03:21 PM. Reason: added information

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code That Extracts Names/Characters Between Characters
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2016, 02:17 PM
  2. [SOLVED] Code that extracts specific sheet in multiple workbooks to one workbook
    By KT999 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-04-2014, 10:05 AM
  3. [SOLVED] Look up last time a code was used and extracts a value related to it
    By MiaRicke in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2014, 04:15 PM
  4. [SOLVED] help on vba code to avoid pop-up stage in middle of code....
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2013, 09:51 PM
  5. Replies: 5
    Last Post: 04-26-2013, 08:32 PM
  6. [SOLVED] Run time error in code that extracts data from several sheets into master sheet
    By Hello23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-23-2012, 10:11 PM
  7. [SOLVED] Code to evaluate contents of one cell then write new values into new cell (Simple IF Stmt)
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2012, 11:54 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