I have a populated spreadsheet and i want to add additional information infront of the current information to each cell. I.e each cell has a variety of colours...bronze, chrome, silver etc and i need to add the phrase 'Colour:' before each entry.
I would normally do find & replace to add this information however almost each cell contains different information so it would takes ages. Is there any way of doing a generic find & replace (by using *, ?, "" for example) to put the information before every single cell in the selection?
Would aprpeciate any help you can give me.
I would normally do find & replace to add this information however almost each cell contains different information so it would takes ages. Is there any way of doing a generic find & replace (by using *, ?, "" for example) to put the information before every single cell in the selection?
Would aprpeciate any help you can give me.