Add a alphabetic character to the beginning of an entire column of

K

Karise

I have one column column of numbers that I want to add a letter to the front
of the numbers.
Help?
 
C

Chip Pearson

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
 
Top