Formula to remove certain text

A

Angela1979

Hi everyone

Could someone please advise what formula to use to remove a word if
present it not leave current text

26 Jan 07
15 Jan 07
Unspecified
Unspecified
Unspecified
01 Feb 07
01 Feb 07
01 Feb 07

I need to delete the word Unspecified, and leave the date as normal.

Many Thanks
 
D

David Biddulph

If you want to do it by formula, use
=SUBSTITUTE(A1,"Unspecified","")

Another option is to use Edit/ Replace
 
T

Teethless mama

Edit > Replace > Find what: Unspecified > Replace with: leave it blank >
Replace All
 
Top