Hi I am new to this forum. I have already gone through the other threads to make sure that I am not asking questions which have already been answered and I have asked two relatively very experienced Excel users but left with no answer, I now humbly request your assistance.
I have a huge database of 60,000 records in excel. There is a column with descriptions with lots of text. I need to extract specific text from each cell and copy it to another column.
The keywords to extract are as follows (the extraction should ignore capitalisation of letters):
“Commercial Property”
“Residential Property”
“Family”
“Divorce”
“Professional Negligence”
“Medical Negligence”
“Clinical Negligence”
“Negligence”
“Personal Injury”
“Conveyancing”
“Residential Conveyancing”
“Commercial Conveyancing”
“Domestic Conveyancing”
“Crime”
“Criminal Law”
“Fraud”
“Serious Organised Crime”
"Wills"
"Probate"
Etc….
The extract data needs to be placed in the column next to the target column.
Where more than one keyword appears in the target cell, the keywords need to be extracted and placed separated by comma.
<tbody>
</tbody>
<tbody>
</tbody>Thank you in anticipation.
I have a huge database of 60,000 records in excel. There is a column with descriptions with lots of text. I need to extract specific text from each cell and copy it to another column.
The keywords to extract are as follows (the extraction should ignore capitalisation of letters):
“Commercial Property”
“Residential Property”
“Family”
“Divorce”
“Professional Negligence”
“Medical Negligence”
“Clinical Negligence”
“Negligence”
“Personal Injury”
“Conveyancing”
“Residential Conveyancing”
“Commercial Conveyancing”
“Domestic Conveyancing”
“Crime”
“Criminal Law”
“Fraud”
“Serious Organised Crime”
"Wills"
"Probate"
Etc….
The extract data needs to be placed in the column next to the target column.
Where more than one keyword appears in the target cell, the keywords need to be extracted and placed separated by comma.
A | B | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
<tbody>
</tbody>