Formula to remove certain text

  • Thread starter Thread starter Angela1979
  • Start date Start date
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
 
=IF(A1="unspecified","",A1)

Regards,
Stefi


„Angela1979†ezt írta:
 
If you want to do it by formula, use
=SUBSTITUTE(A1,"Unspecified","")

Another option is to use Edit/ Replace
 
Thanks everyone for you help.
I am so gald I have found this site.
 
Edit > Replace > Find what: Unspecified > Replace with: leave it blank >
Replace All
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to transform the dates to months 4
Date Function 5
Display Months by looking at the dates 3
how to create a formula with expiry condition 2
IF condition using GMT and BST times 4
how interest is calculated for running balances 1
to lookup data for 'today()' 2
How to determine the value? 1

Back
Top