Combining formulas

[HomePro]

I am trying to simplify an existing workbook.
I have almost 1000 lines and over 50 headers so reviewing it is an eyesore.

Right now I am creating two columns. the first formula parses the entry from a data cell that looks like:
Single-Family Home (Residential Inspection) ($23.60) | 4 Point Insurance Evaluation ($0.00) | WDO Inspection - FL ONLY - Primo ($50.00)
So if the column header is wdo the cell populates " WDO Inspection - FL ONLY - Primo ($50.00)"
and then the second parses the $ value so the results are 50.00.

Is there anyway I can combine these two formulas into one?
=IFERROR(TRIM(LEFT(SUBSTITUTE(REPLACE($E3,1,SEARCH(G$1,$E3)-1,""),"|",REPT(" ",999)),999)),"")
and
=IFERROR(SUBSTITUTE(REPLACE(G3,1,SEARCH("$",G3),""),")","")+0,"")

If I could get the 50 result and remove 50 columns it would be so much easier.

any ideas?

 

[Candyman8019]

It would help to have a sample of your worksheet. For example, to understand what is in G3 and E3?

 

[Fluff]

Do you mean that you don't want to extract the WDO Inspection - FL ONLY - Primo ($50.00) but just the 50.00?

 

[HomePro]

Fluff.. yes Exactly.

 

[Fluff]

Ok, how about

=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(REPLACE($E3,1,SEARCH(G$1,$E3)-1,""),"$","")," ",REPT(" ",100)),100))*-1

 

[HomePro]

Does not seem to return the right values.

 

[Fluff]

Is this what you want

Fluff.xlsm
	E	F	G
1			WDO
2
3	Single-Family Home (Residential Inspection) ($23.60) | 4 Point Insurance Evaluation ($0.00) | WDO Inspection - FL ONLY - Primo ($50.00)		50
Data

Cell Formulas
Range	Formula
G3	G3	=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(REPLACE($E3,1,SEARCH(G$1,$E3)-1,""),"$","")," ",REPT(" ",100)),100))*-1

 

[HomePro]

Yes, exactly. Wonder why id di not work in mine. Will review again.
Thank you

 

[Fluff]

Glad to help & thanks for the feedback.

 

[HomePro]

Glad to help & thanks for the feedback.

Fluff, Sorry cant get this to work. The columns changed some since I started but the issue is the same.
Will this help?
Trying to place this formula in column DA thru ee [ but I am only showing you a few to get the idea] and the reference cell is now BU

Appointment_General_Data.xlsx
																																																																									BU																																DA	DB	DC	DD	DE	DF	DG
1																																																																									Pricing_Attributes																																4 Point	Additional Price	Air Sampling	Asbestos Testing	Condominium	Convenience Fee	Discount Code
2																																																																									Single-Family Home (Residential Inspection) ($1323.60) | 4 Point Insurance Evaluation ($0.00) | WDO Inspection - FL ONLY - Primo Pest ($0.00) | Wind Mitigation Assessment ($0.00) | Florida Package ($297.00) | Convenience Fee ($56.72)																																56.72	#VALUE!	#VALUE!	#VALUE!	#VALUE!	56.72	#VALUE!
3																																																																									Single-Family Home (Phase 3 - Mattamy - New Construction: Final Inspection) ($424.00) | Sewer Line Inspection ($223.00) | Convenience Fee ($22.65)																																#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	22.65	#VALUE!
4																																																																									WDO Inspection - FL ONLY - Primo Pest ($197.00) | Convenience Fee ($6.90)																																#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	6.9	#VALUE!
5																																																																									WDO Additional Visit - FL ONLY - Primo Pest ($115.00)																																#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
6																																																																									4 Point Insurance Evaluation ($157.00) | Discount Code JWB4PT applied ($-82.00)																																#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
7																																																																									4 Point Insurance Evaluation ($157.00) | Discount Code JWB4PT applied ($-82.00)																																#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
8																																																																									Wind Mitigation Assessment ($132.00) | Convenience Fee ($4.62)																																#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	4.62	#VALUE!
9																																																																									Single-Family Home (Phase 2 - New Construction: Framing & Mechanicals Inspection) ($444.00) | Convenience Fee ($15.54)																																#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	15.54	#VALUE!
10																																																																									Additional Price for properties 40 to 50 mile away ($10.00) | Single-Family Home (Residential Inspection) ($397.00) | 4 Point Insurance Evaluation ($85.00) | WDO Inspection - FL ONLY - Primo Pest ($157.00) | Wind Mitigation Assessment ($85.00) | Convenience Fee ($25.69)																																25.69	25.69	#VALUE!	#VALUE!	#VALUE!	25.69	#VALUE!
Sheet1

Cell Formulas
Range	Formula
DA2:DG10	DA2	=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(REPLACE($BU2,1,SEARCH(DA$1,$BU2)-1,""),"$","")," ",REPT(" ",100)),100))*-1