How to do this in Excel?

[Ironic Namesake]

I have a list of products, and I need to add the manufacturer name into the description cell , I can do this manually ie. double click beginning of name, then paste manufacturer name (will do them one by one) but is there any other way of doing this?

Have around 3000 products to do , and I'll get bored quickly if I do this manually

Thanks in advance

 

[Ironic Namesake]

That's what the spreadsheet looks like, all those items are from the same manufacturer, they're all in blocks.

Cogwork, thanks I'll try your suggestion

 

[Ironic Namesake]

Yup that works perfectly Excel comes in very useful at times , great piece of kit - find a new function every time I get stuck !