| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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 , 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting text data in a cell | Excel Worksheet Functions | |||
| Pivot Table - Extracting specific data | Excel Worksheet Functions | |||
| Extracting data from a client worksheet to create an invoice | Excel Discussion (Misc queries) | |||
| Extracting data from other columns | Excel Worksheet Functions | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Linear Mode
