Two ways:
if A1 contains 15070, then in another cell enter ="BP" & A1
this will get a string.

The other way is to format A1 Custom "BP"General
This will appear as BP15070 but can still be used as a number.
-
Gary's Student


"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