Sorry if I posted in the wrong place - wasn't sure where this should go.
Anyway my problem is that I have a spreadsheet that has a couple of hundred rows in it, each row having a cell (column A) in it that has a content similar to;
'This ink cartridge is for the &PRINTER printer'
and on the same row I have another cell (column B) that holds the value of &PRINTER
My question is, how do I replace the &PRINTER in column A with the value in column B?