Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | This year's Gross profit is $100000 | This year's | ||
2 | Last month's Net Lost was $1000 | Last month's | ||
Sheet576 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =TRIM(LEFT(A1,MIN(SEARCH("Gross",A1&"Gross"),SEARCH("Net",A1&"Net"))-1)) |
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | The fund raiser netted $5000, while his year's Gross profit is $100000 | The fund raiser netted $5000, while his year's | ||
2 | The project is grossing the expected profit, but last month's Net Lost was $1000 | The project is grossing the expected profit, but last month's | ||
Sheet576 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =TRIM(LEFT(A1,MIN(SEARCH(" Gross "," "&A1&" Gross "),SEARCH(" Net "," "&A1&" Net "))-1)) |
Input | Output |
CREDIT 129 IN NET 0.40 0.47 1.40 1.35 5.27 7.13 - 1.16 | CREDIT 129 IN |
CREDIT258 NL F GROSS 0.40 0.47 1.40 1.35 5.27 7.13 - 1.16 | CREDIT258 NL F |
Report as net of fee | |
Report is Gross of fee Fund or net | |
Gross fee is net of |
=TRIM(REPLACE(A52,1,LEN(B52),""))