Finding specific text in string - Part II

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All

Ron & Gary kindly provided the work sheet function in the previous thread.

I now need to create a separate column with only those cells that are
populated with a true outcome. At present all my cells in the Column C are
populated with C2: =IF(ISNUMBER(FIND("Project 2000",B2)),"Project 2000","").

Where the statement is true I'd like to copy only the content into cells in
Column D - i.e. as a word not a formula. Where there is a false i.e. "" -
I'd like to leave that blank / empty.

I'd appreciate any guidance on how to achieve this.

Thanks in advance,
H
 

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

Finding specific text in a string 5
FINDING AN EXACT MATCH ON 2 DIFFERENT SHEETS THEN EXECUTING A FORM 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Trying to calculate # of times text string is displayed 1
sumproduct - find text in string 11
countifs Function not giving desired result with date criteria 2
Countif and sumif combination problem 2
Finding a single word match in a text string and assigning a code 8

Back
Top