Add a alphabetic character to the beginning of an entire column of
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" wrote in message ... I have one column column of numbers that I want to add a letter to the front of the numbers. Help? |
All times are GMT +1. The time now is 04:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com