Forum Discussion
Solved
replace function
I am looking for a way to replace text in a cell based on one word like Dept: Fredy's Crew I should just enter Dept: and it should replace the entire cell
Do you want to clear cells whose content starts with Dept: ?
If so, enter Dept:* in the 'Find what' box.
thx but where can I get that info from