adding a prefix to cells

I have a column of 4 digit numbers and I want to add "H02-" to each number. How do I do that without having to type it in each row?

Thanks

Paul

Hi,

Please Login or Register  to view this content.

HTH
Carim

Thanks Carim, but I'm not sure where to type the code.....I'm not very Excel literate!

Hi,

The assumption is your data is located in column A, starting in cell A1 ...
so formula would need to be copied in cell B1 ... and then all the way down ..

HTH
Carim

Thanks. The penny drops.

Paul

Glad your problem is fixed

Thanks for the feedback

Carim