|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 14th, 2009, 04:44 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting information to automatically find previous value.
I have the following information $442,400 $+16,900 ($+1,200) contained in one
cell & would like to be able to subtract the 2nd figure $+16,900, from the first figure $442,400 using a text formula in another cell. I have tried a few formulas, but the problem is that the numbers involved can be in the hundreds of dollars anywhere up to hundreds of thousands of dollars. Any help would be greatly appreciated. Thanks in advance. 
|
|
#2
June 14th, 2009, 06:33 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting information to automatically find previous value.
$442,400 $+16,900 ($+1,200) contained in one cell
Assuming the 2nd set of digits is *always* preceded by a space then 2 characters and followed by a space: =LEFT(A1,FIND(" ",A1)-1)-MID(A1,FIND(" ",A1)+3,FIND(" ",A1,FIND(" ",A1)+1)-(FIND(" ",A1)+3)) -- Biff Microsoft Excel MVP "Rocko" wrote in message ... I have the following information $442,400 $+16,900 ($+1,200) contained in one cell & would like to be able to subtract the 2nd figure $+16,900, from the first figure $442,400 using a text formula in another cell. I have tried a few formulas, but the problem is that the numbers involved can be in the hundreds of dollars anywhere up to hundreds of thousands of dollars. Any help would be greatly appreciated. Thanks in advance.
|
|
#3
June 15th, 2009, 04:16 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting information to automatically find previous value.
Thanks so much for your prompt reply Biff. That worked brilliantly!
"T. Valko" wrote: $442,400 $+16,900 ($+1,200) contained in one cell Assuming the 2nd set of digits is *always* preceded by a space then 2 characters and followed by a space: =LEFT(A1,FIND(" ",A1)-1)-MID(A1,FIND(" ",A1)+3,FIND(" ",A1,FIND(" ",A1)+1)-(FIND(" ",A1)+3)) -- Biff Microsoft Excel MVP "Rocko" wrote in message ... I have the following information $442,400 $+16,900 ($+1,200) contained in one cell & would like to be able to subtract the 2nd figure $+16,900, from the first figure $442,400 using a text formula in another cell. I have tried a few formulas, but the problem is that the numbers involved can be in the hundreds of dollars anywhere up to hundreds of thousands of dollars. Any help would be greatly appreciated. Thanks in advance.
|
|
#4
June 15th, 2009, 04:26 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting information to automatically find previous value.
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Rocko" wrote in message ... Thanks so much for your prompt reply Biff. That worked brilliantly! "T. Valko" wrote: $442,400 $+16,900 ($+1,200) contained in one cell Assuming the 2nd set of digits is *always* preceded by a space then 2 characters and followed by a space: =LEFT(A1,FIND(" ",A1)-1)-MID(A1,FIND(" ",A1)+3,FIND(" ",A1,FIND(" ",A1)+1)-(FIND(" ",A1)+3)) -- Biff Microsoft Excel MVP "Rocko" wrote in message ... I have the following information $442,400 $+16,900 ($+1,200) contained in one cell & would like to be able to subtract the 2nd figure $+16,900, from the first figure $442,400 using a text formula in another cell. I have tried a few formulas, but the problem is that the numbers involved can be in the hundreds of dollars anywhere up to hundreds of thousands of dollars. Any help would be greatly appreciated. Thanks in advance.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
