Results 1 to 10 of 10

Need help extracting data from text

Threaded View

  1. #1
    Registered User
    Join Date
    01-10-2013
    Location
    Cardiff, CA
    MS-Off Ver
    Excel 16.49 for Mac
    Posts
    15

    Need help extracting data from text

    I have been humbled (once again) by Excel! I am running tests on prototypes of a new fitness device. As part of our tests, we collect data from an accelerometer. I receive the data in this format: {X,Y,Z}. I can transfer the data from our test fixture to an Excel file - see attached as an example.

    The accelerometer data are in column D. I want to extract the X, Y and Z values and put them in columns E, F and G. I tried using the MID function to extract the data, but that didn't work because the length of the data varies. For example, it could be a single-digit number (such as 5). Or it could be a two-digit number (such as 17 or -8). It could be a three-digit number (such as -21). In rare cases, it could be a three-digit positive number (such as 126) or a four-digit negative number (such as -208).

    With thanks in advance, does anybody have any suggestions for extracting the values of X, Y and Z and placing them in separate columns?

    Cheers,
    Clint

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. extracting data based on text
    By nobodytwok in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2013, 09:43 AM
  2. Extracting data from this text format
    By teachme in forum Excel General
    Replies: 17
    Last Post: 08-21-2008, 12:55 AM
  3. Extracting strings of text from Columns of data(text)
    By welshmagic69 in forum Excel General
    Replies: 9
    Last Post: 04-23-2007, 02:50 PM
  4. [SOLVED] Extracting Text Data to Excel
    By Ozzie via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2006, 01:35 PM
  5. [SOLVED] extracting text data in a cell
    By gareth1983 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 12:05 AM

Tags for this Thread

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