How to pull certain information into separate columns

[Xiaobai]

Hello,

We would like to pull certain information (Project Name and Entity Name) from a field. The field has plenty unnecessary information and descriptions. Please see the example below:

Field: "Bonnie and Peter did a proposal for Project Apple on Monday to Company ABC" or "Memo for Berry for DEF"

The output we want:

Field 1	Project Name	Entity Name
Bonnie and Peter did a proposal for Project Apple on Monday to Company ABC	Apple	ABC
Memo for Berry for DEF	Berry	DEF

We have the full list of the project name and entity name with us in a separate excel file. Currently we are using the formula below for each project but it is a little bit time consuming, I am wondering if there is an easier way to solve this issue.

IF Contains([Field 1], "Apple") THEN "Project Apple" ELSE "" ENDIF

[binuacs · Accepted solution]

@Xiaobai If you the list of separate Project and Entity you can use the Find and replace tool

[Xiaobai]

Thanks a lot @binuacs! This solves my issue!!

[atcodedog05]

@Xiaobai 

Solution authors are Happy to help : )

If the solution author's response helps please don't forget to mark it as a solution.

Cheers and have a nice day!

[Xiaobai]

Thanks for the reminder! Just marked it as solved.