I am trying to standardize part descriptions for multiple manufacturing locations, as each facility uses different language to describe the same item. Is there a function/formula in excel that would allow me to look for specific text and then replace the entire content of the cell with a new definition? For example, one facility lists a part as "12" Blum, 230M3000" while another lists same part as "12" Epoxy, 230M3000". Could I search each spreadsheet for "230M3000" and replace with "12" Epoxy, Blum 230M3000?" I tried find/replace, but it would only replace the string of text that I searched for -- not the entire content of the cell.
Thanks,
David
Bookmarks