Thread: HOW DO I ADD A LETTER BEFORE AN EXISTING NUMBER IN A CELL?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default HOW DO I ADD A LETTER BEFORE AN EXISTING NUMBER IN A CELL?
In a cell next to your number (say A1 has the number, so in B1),

="A"&A1 (or whatever letter you want inside the quotes)

If you want to get rid of the formulas, select the column, Edit|Copy
and then Edit|Paste Special... checking Values.

HTH
Kostis Vezerides

Reply With QuoteReply With Quote