Parsing data from a cell

[HomePro]

I have one cell that can contain several data points i want to parse into dedicated columns. So 1 for wdo one for 4 pt one for wind mit, etc.
Can anyone help?

WDO Inspection - FL ONLY (by Primo Pest) ($149.00) | 4 Point Insurance Evaluation ($75.00) | Wind Mitigation Assessment ($75.00) | Single-Family Home (Residential Inspection) ($699.00) | Additional Price for properties 60 to 70 mile away ($10.00) | Convenience Fee ($35.28)

Water Testing ($249.00) | Single-Family Home (Residential Inspection) ($459.00) | WDO Inspection - FL ONLY (by Primo Pest) ($149.00) | 4 Point Insurance Evaluation ($75.00) | Wind Mitigation Assessment ($75.00) | Additional Price for properties 50 to 60 mile away ($10.00)

WDO Inspection (by Primo Pest) ($149.00) | 4 Point Insurance Evaluation ($75.00) | Wind Mitigation Assessment ($75.00) | Single-Family Home (Residential Inspection - FL) ($819.00) | Water Testing ($249.00) | Asbestos Testing - Bulk Materials ($99.00)

WDO Inspection - FL ONLY (by Primo Pest) ($149.00) | Single-Family Home (Residential Inspection) ($459.00) | Water Testing ($249.00) | Additional Price for properties 90 to 100 mile away ($40.00) | Convenience Fee ($31.40)

Single-Family Home (Residential Inspection) ($519.00) | 4 Point Insurance Evaluation ($75.00) | Wind Mitigation Assessment ($75.00) | Additional Price for properties 50 to 60 mile away ($10.00) | Convenience Fee ($23.77)

 

[HomePro]

Dante, Is it also possible to add a column and extract the $ values between the ( )?

 

[DanteAmor]

Is it also possible to add a column and extract the $ values between the ( )

Try:

Dante Amor
	A	B	C	D	E	F	G	H	I	J	K	L	M
1		WDO	$	4 Point Insurance Evaluation		Wind Mitigation Assessment	$	Single-Family Home	$	Additional Price for properties	$	Convenience Fee	$
2	WDO Inspection - FL ONLY (by Primo Pest) ($149.00) | 4 Point Insurance Evaluation ($75.00) | Wind Mitigation Assessment ($75.00) | Single-Family Home (Residential Inspection) ($699.00) | Additional Price for properties 60 to 70 mile away ($10.00) | Convenience Fee ($35.28)	WDO Inspection - FL ONLY (by Primo Pest) ($149.00)	149	4 Point Insurance Evaluation ($75.00)	75	Wind Mitigation Assessment ($75.00)	75	Single-Family Home (Residential Inspection) ($699.00)	699	Additional Price for properties 60 to 70 mile away ($10.00)	10	Convenience Fee ($35.28)	35.28
3	Water Testing ($249.00) | Single-Family Home (Residential Inspection) ($459.00) | WDO Inspection - FL ONLY (by Primo Pest) ($149.00) | 4 Point Insurance Evaluation ($75.00) | Wind Mitigation Assessment ($75.00) | Additional Price for properties 50 to 60 mile away ($10.00)	WDO Inspection - FL ONLY (by Primo Pest) ($149.00)	149	4 Point Insurance Evaluation ($75.00)	75	Wind Mitigation Assessment ($75.00)	75	Single-Family Home (Residential Inspection) ($459.00)	459	Additional Price for properties 50 to 60 mile away ($10.00)	10
4	WDO Inspection (by Primo Pest) ($149.00) | 4 Point Insurance Evaluation ($75.00) | Wind Mitigation Assessment ($75.00) | Single-Family Home (Residential Inspection - FL) ($819.00) | Water Testing ($249.00) | Asbestos Testing - Bulk Materials ($99.00)	WDO Inspection (by Primo Pest) ($149.00)	149	4 Point Insurance Evaluation ($75.00)	75	Wind Mitigation Assessment ($75.00)	75	Single-Family Home (Residential Inspection - FL) ($819.00)	819
5	WDO Inspection - FL ONLY (by Primo Pest) ($149.00) | Single-Family Home (Residential Inspection) ($459.00) | Water Testing ($249.00) | Additional Price for properties 90 to 100 mile away ($40.00) | Convenience Fee ($31.40)	WDO Inspection - FL ONLY (by Primo Pest) ($149.00)	149					Single-Family Home (Residential Inspection) ($459.00)	459	Additional Price for properties 90 to 100 mile away ($40.00)	40	Convenience Fee ($31.40)	31.4
6	Single-Family Home (Residential Inspection) ($519.00) | 4 Point Insurance Evaluation ($75.00) | Wind Mitigation Assessment ($75.00) | Additional Price for properties 50 to 60 mile away ($10.00) | Convenience Fee ($23.77)			4 Point Insurance Evaluation ($75.00)	75	Wind Mitigation Assessment ($75.00)	75	Single-Family Home (Residential Inspection) ($519.00)	519	Additional Price for properties 50 to 60 mile away ($10.00)	10	Convenience Fee ($23.77)	23.77
Hoja5

Cell Formulas
Range	Formula
B2:B6,L2:L6,J2:J6,H2:H6,F2:F6,D2:D6	B2	=IFERROR(TRIM(LEFT(SUBSTITUTE(REPLACE($A2,1,SEARCH(B$1,$A2)-1,""),"|",REPT(" ",999)),999)),"")
C2:C6,M2:M6,K2:K6,I2:I6,G2:G6,E2:E6	C2	=IFERROR(SUBSTITUTE(REPLACE(B2,1,SEARCH("$",B2),""),")","")+0,"")

 

[HomePro]

tks