I’m looking for a way to search through a column and remove the price if it exists. If not, make no changes. What needs to be removed is always on the right side of the string. The various versions that need to be changed look something like this:
ALIGNMENT $79.95
SIDE MIRROR. PARTS $283
TIMING BELT…..556.00
I’d like the results to look like this:
ALIGNMENT
SIDE MIRROR.
TIMING BELT
I thank you for your help.
Bookmarks