Thread: How to add a prefix to a column of numbers in an excel document?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
  
Posts: 1,522
Default How to add a prefix to a column of numbers in an excel document?
On Friday, April 18, 2008 1:39:01 PM UTC-5, Beth wrote:
Our company is altering the code of our item numbers. is there a way to
delete one letter from a line of symbols and add a prefix to the front at the
same time?

If there are no other "b"'s in the number then simply select the column header and use datareplaceb with a....
Reply With QuoteReply With Quote