I have a huge csv spreadsheet file that contains about 1500 lines/cells like the ones below.

Each line is in a cell in the spreadsheet...

Kitchen Cabinet Hardware: Knobs | P2152-OBH | Hickory Hardware | Bronze or Copper | Oil-Rubbed Bronze Highlighted | Bungalow | DesignerKnobsAndPulls.com
Kitchen Cabinet Hardware: Knobs | P2152-PN | Hickory Hardware | Silver Tones | Pearl Nickel | Bungalow | DesignerKnobsAndPulls.com


Every line has "Kitchen Cabinet Hardware:" I need to delete this on every line. I can obviously find that but what do I use for "replace" to delete them all?

After that, every line has a part that starts with "Hickory Hardware" and ends with "DesignerKnobsAndPulls.com". I am going to replace the part between these two with the same thing on every line where now it has different things between on each line.

What would the find string be for...
Hickory Hardware | wildcard here | DesignerKnobsAndPulls.com