Excel formulas

[msummers13157]

I am looking for a formula that will allow me to maybe use a wildcard to change a columns text from one specific to another that makes it easier than hunt and peck or using the find/replace method

 

[awoohaw]

Welcome to the forum.

Please post a scenario with before and after expectations. Mr. Excel has a tool that allows you to post mini worksheets of your workbook that enables the forum (and you when you get a return suggestion) to quickly copy the scenario. Please see the xl2bb add in link below. If you cannot use the the add in, then please post a table, with labels and formulas in the text of the post description.

Having to build a scenario from scratch can lead to unnecessary effort by the forum and you.
Please help the forum help you.