I have one column column of numbers that I want to add a letter to the front
of the numbers.
Help?
I have one column column of numbers that I want to add a letter to the front
of the numbers.
Help?
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" <Karise@discussions.microsoft.com> wrote in message
news:DDE68129-A198-4810-ADDD-33F0DD179FB0@microsoft.com...
>I have one column column of numbers that I want to add a letter
>to the front
> of the numbers.
> Help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks