adding characters in excel column

R

rita

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
 
G

Gary''s Student

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
 
D

daddylonglegs

If your numbers are in column A then in B1

="BP"&A1

and copy down column

If you want to replace the numbers in column A with these then Cop
column B and use

Edit > PasteSpecial > values to paste over column
 
G

George

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
 
Top