+ Reply to Thread
Results 1 to 2 of 2

extracting numerical data

  1. #1
    sroehl
    Guest

    extracting numerical data

    I have cells in my worksheet containing results from using ="text"&COUNTIF...
    For example, one cell contains "exc 9", because there are nine times "exc"
    is seen in the column. I want to know if I can extract the numerical data
    from these cells to use in pie charts. Excel 2002 SP-2.

  2. #2
    Tushar Mehta
    Guest

    Re: extracting numerical data

    If the number you want to extract always has a leading space before it,
    you can use =0+TRIM(MID(A1,FIND(" ",A1),1024)) where A1 contains the
    string of interest.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > I have cells in my worksheet containing results from using ="text"&COUNTIF...
    > For example, one cell contains "exc 9", because there are nine times "exc"
    > is seen in the column. I want to know if I can extract the numerical data
    > from these cells to use in pie charts. Excel 2002 SP-2.
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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