| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can I subtract excel cell values that contain both a number a.
I have measurement data from an ATE system where the results are given as
both a number and 'unit' letters for example 22.3 dB, 2.109 MHz, 12.06 V and 0.175 A. To calculate temperature drift from these readings, I need to subtract cells that contain both a number and a letter i.e. 2.012 MHz - 2.005 MHz = 0.007 does not matter if the answer contains the 'units' or not. anyone know how I can achieve this ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Toggle multiple values in single cell | Excel Worksheet Functions | |||
| In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
| Can you reference cell values in Headers and Footers in Excel 200. | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Threaded Mode
