Wildcats23
New Member
- Joined
- Dec 6, 2018
- Messages
- 10
A | B | C | D |
Test | |||
Water Pressure Test--test 21 | |||
Test 21 | |||
Water Test --- 21 | |||
Test---21 | |||
Pressure Test |
<tbody>
</tbody>
I need help writing an if statement that searches for a number(or phrase) is in a Cell. I want it to find if "21" or "Pressure Test" is in the cell then make the entire cell just "21". I would write a formula to do this but there are a lot of different tests so I would like to write a macro instead. THANK YOU!!!