View Single Post
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

In a new column, enter the formula

="letter"&A1

Change the A1 to the appropriate cell, and fill down the formula
as far as you need to go. Then, select the cells in the new
column, copy them, and Paste Special (from the Edit menu) and
choose Values Only.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Karise" wrote in message
...
I have one column column of numbers that I want to add a letter
to the front
of the numbers.
Help?