replace function

[wanalearn]

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

[#2 · Accepted solution]

@wanalearn

Do you want to clear cells whose content starts with Dept: ?

If so, enter Dept:* in the 'Find what' box.

[#3]

thx but where can I get that info from

[#4]

@wanalearn 

See:

Using wildcard characters in searches 

Wildcard 

[#5]

thx