Hi,
I had posted this yesterday but the post has disappeared for some reason. So posting again. Apologies to Fennek and Special-K99 who replied yesterday.
I have a sheet with one column containg some descriptive text:
<tbody>
</tbody>
I have some reference values: eg: Black, Blue, Yellow, Brown, Red, Blue green, ....and about 145 other values
Is there some way to delete all words in A except for the reference values?
Desired output:
<tbody>
</tbody>
I had posted this yesterday but the post has disappeared for some reason. So posting again. Apologies to Fennek and Special-K99 who replied yesterday.
I have a sheet with one column containg some descriptive text:
A | B | |
1 | Dark brown marked with bright yellow spots. | |
2 | Black marked with bright yellow spots. | |
3 | Blue marked with greenish yellow markings. | |
4 | Brown marked with bright yellow spots. |
<tbody>
</tbody>
I have some reference values: eg: Black, Blue, Yellow, Brown, Red, Blue green, ....and about 145 other values
Is there some way to delete all words in A except for the reference values?
Desired output:
A | B | |
1 | Dark brown marked with bright yellow spots. | brown, yellow |
2 | Black marked with bright yellow spots. | black, yellow |
3 | Blue marked with greenish yellow markings. | blue, yellow |
4 | Brown marked with bright red spots. | brown, red |
<tbody>
</tbody>