adding characters in excel column
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 |
adding characters in excel column
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 |
adding characters in excel column
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 |
adding characters in excel column
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 |
All times are GMT +1. The time now is 12:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com