View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] grativo@aol.com is offline
external usenet poster
 
Posts: 1
Default Insert a letter in front of number in every cell?

I have a whole column of numbers which I would like to add a letter to
in the beginning. For example, if the cell has the number 2350, I
would like to change the cell to B2350. How do I do this without
manually changing the data on every cell?