Thread: adding characters in excel column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote