Prefixing numerics with an Alpha code

[Safequip]

I have a supplier price manual (3000 plus rows)with product numeric codes ie 12345, my own internal codes should begin with an abbreviated 3 digit alpha code ie ABC12345 does anyone know how I can change this without having to do each individually? As always your help is appreciated.

 

[Hui]

Add a new Column say B

="ABC"&A2

Copy down

Copy/Paste Column b as values over itself

Delete Column A

 

[Safequip]

Hui - Mwahhh I could hug ya thank you so much xx