Adding a character to values within a column

[paul29berks]

I wondered if someone could help.

I have 1 column that contains a row of values in the format N12345. There are some 2000 rows.

In a seperate column I need to add 1 character to each of these values i.e HN12345.


How can I do this?

Thanks

 

[GlennUK]

="H"&A1

and copy down. Adjust the A1 reference if necessary.

 

[paul29berks]

Thanks