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

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

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=513400

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