+ Reply to Thread
Results 1 to 2 of 2

help graphing imported data

  1. #1
    Registered User
    Join Date
    07-11-2017
    Location
    US
    MS-Off Ver
    NEWEST
    Posts
    1

    help graphing imported data

    I am importing data from a serial port
    each cell is filled with a number (just what i wanted) . however the number is followed by a space then g or space then g?.


    The number I want and need to graph but the g or g? makes the chart function not recognize the cell as a numerical data value.

    The only way I can get an apropriate graph is to delete one by one the g or g? in each cell

    The data stream averages about 250 cells there must be a easy way to remove all of them with a formula or filter or somthing
    I do not know anything about excel or spread sheets in general and have not been able to find a solution.


    Any Help???

    Thanks
    Dan
    Last edited by zafh15a; 07-11-2017 at 09:40 PM. Reason: poor example

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: help graphing imported data

    hi
    search and replace is probably your easiest method

    or, this formula will find the values to the left of the space in cell A1, assuming all of your cells contain a number, then space, then text

    Please Login or Register  to view this content.

+ 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. [SOLVED] Live graphing comparing manually entered data with existing data
    By Desert Coyote in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 05-15-2015, 03:05 PM
  2. [SOLVED] inserting a timestamp on the data sheet when a raw data file is imported
    By macrorookie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2014, 02:18 PM
  3. [SOLVED] Macro to pull imported data from sheet2 and place data in specific rows on sheet1
    By PatRiot199 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-05-2013, 04:22 PM
  4. Replies: 1
    Last Post: 08-11-2012, 05:43 PM
  5. Excel graphing from information imported from Access
    By cchampagne17 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-04-2012, 12:30 AM
  6. Graphing Data
    By seanrigby in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-20-2009, 08:09 AM
  7. add imported text file name above imported data
    By tompie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2009, 08:18 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