Insert a letter in front of number in every cell?
="B"&A1 and copy down.
--
David Biddulph
wrote in message
ups.com...
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?
|