I’d like to find a way to go down column “J” and copy it to column “K”. But if it exist, when copying to column “K”, trim the first “.” in a cell and everything after that. And also, if it exist, trim the first “$” in a cell and everything after that.
I’d like it to look like this:
Column J Column K
Fluid Service…..69.95 Fluid Service
Air Filter….21.00 Air Filter
Clutch Fluid Service$69.95 Clutch Fluid Service
Brake Job Brake Job
Thank You for your help.
Bookmarks