adding characters in excel column

[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

[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 Copy column B and use

Edit > PasteSpecial > values to paste over column A

[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


"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
>

[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

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
>