Lets assume the numbers are in column A
Then in column B type
="BP"&A1
Then copy down

If its only for display, and you don't actually need the letters in any
calculations. Try adjusting the cell number format
Format Cells Number then Select custom
Type the following
"BP"0

George

rita wrote:
I would like to know how to add a character in front of the #s(each row is
different #) in a column on excel? for example:
15070 to BP15070
15093 to BP15093, etc.

Please advise.

rita