View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PaulPA PaulPA is offline
external usenet poster
 
Posts: 1
Default adding a prefix to cells


I wish to add "B03-" to each cell in a column of numbers. I'm sure it's
really simple to do, but I can't seem to find out how. The column has
about 1,500 four digit numbers, so I don't want to do it manually.
Please could someone help me!


--
PaulPA
------------------------------------------------------------------------
PaulPA's Profile: http://www.excelforum.com/member.php...o&userid=36454
View this thread: http://www.excelforum.com/showthread...hreadid=562171