vba replace

Hello. I have 1100 part numbers in column A, against that in Column B we have some data that has been entered on separate lines within the cell Part Number Origial Part 1 Audi (A3 A4) BMW (5 6 7) Volvo (V50 S40) Mercedes (C S) BMW (5 6 7) Volvo (V50 S40) Part 2 Mercedes (C S) BMW (5 6...

I'm using the "replace" function to revise a chart formula (to shift the Name, X, and Y ranges a specified number of columns to the right). The replace works correctly the first time through the loop, but the second time it misses an occurrence of the search string. It replaces the text at...

Hello. I have an excel file I download that has columns with cell contents that look like this: /great/chicken/sautéed/AA41. I want only the “AA41” left with everything beforehand deleted. The columns are H:1-H:2000. For extra reference there are always 9 “/“ characters so it would always be...

Using existing list of classes, which are named in the format: 8A/Cp or 13W/Ma. I can print dynamic class lists for our teachers My existing code works well for printing, but because of the "/" (which we can't change) I can't PDF the files. The existing code I use is a simple print and repeat...

I have one sheet with a Vendor column that has non-exact matches. (e.g. Walmart #6511 vs. Walmart #1654). I want to make all of those nonexact matches the same (Turn the example values into just Walmart.) I was not able to find a way to directly remove the non-exact matches. This led me to...