H
hisimage
I have a huge csv spreadsheet file that contains about 1500 lines/cell
like the ones below.
Each line is in a cell in the spreadsheet...
Kitchen Cabinet Hardware: Knobs | P2152-OBH | Hickory Hardware | Bronz
or Copper | Oil-Rubbed Bronze Highlighted | Bungalow
DesignerKnobsAndPulls.com
Kitchen Cabinet Hardware: Knobs | P2152-PN | Hickory Hardware | Silve
Tones | Pearl Nickel | Bungalow | DesignerKnobsAndPulls.com
Every line has "Kitchen Cabinet Hardware:" I need to delete this o
every line. I can obviously find that but what do I use for "replace" t
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 th
part between these two with the same thing on every line where now i
has different things between on each line.
What would the find string be for...
Hickory Hardware | wildcard here | DesignerKnobsAndPulls.co
like the ones below.
Each line is in a cell in the spreadsheet...
Kitchen Cabinet Hardware: Knobs | P2152-OBH | Hickory Hardware | Bronz
or Copper | Oil-Rubbed Bronze Highlighted | Bungalow
DesignerKnobsAndPulls.com
Kitchen Cabinet Hardware: Knobs | P2152-PN | Hickory Hardware | Silve
Tones | Pearl Nickel | Bungalow | DesignerKnobsAndPulls.com
Every line has "Kitchen Cabinet Hardware:" I need to delete this o
every line. I can obviously find that but what do I use for "replace" t
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 th
part between these two with the same thing on every line where now i
has different things between on each line.
What would the find string be for...
Hickory Hardware | wildcard here | DesignerKnobsAndPulls.co