I would like to automate a process.
In one column I have cells with words, some contain brand names, some don’t.
In the second column I need to write ‘Brand’ in every cell next to the one that has a brand name in it.
I have a list of brands that appear in my document.
Do I understand correctly that I will be able to do it with a function? Or do I need different approach?
Below you will find sample from my document
D6 and D8 contain a brand name, I would need to have a word ‘brand’ in the cell next to them
EDIT: of course I will add them, thank you! brand question.ods