Hi,
I am a new to this forum with below average VBA expierience (googling and coping, modifying)
I need help with VBA coding for command button on an Excel template, Column B on the spredsheet gets the Part Description vaules, we copy and paste from Customers excel and unfortunatly some descriptions contain 3asteriks in a row (***) and I need to import this into Access later on and Access will not except asteriks.
Find and replace doesnt seem to work like i hoped , it replaces everything in cell not just part of it
If someone has a Formula that will work that would be ok too, it does not have ot be VBA
EXAMPLE Part Descriptions:
RADIAL TIE DOWN LUG (4/500's) *** Formed
FINES V-PLOW/ SCRAPER MOUNT ANGLE; Rev. A ***Formed
I only need the asteriks deleted
Thanks so much in advance for your help !
Bookmarks