Formula to remove certain text
 

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

Formula to remove certain text
 

=IF(A1="unspecified","",A1)

Regards,
Stefi


€žAngela1979€� ezt Ã*rta:

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

Formula to remove certain text
 

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

Another option is to use Edit/ Replace
--
David Biddulph

"Angela1979" wrote in message
oups.com...
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

Formula to remove certain text
 

Thanks everyone for you help.
I am so gald I have found this site.

Formula to remove certain text
 

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


"Angela1979" wrote:

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