| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel | |||
| Adding a character to the beginning and end of txt in a cell | Excel Worksheet Functions | |||
| Cell 255 character limit and formula | Excel Worksheet Functions | |||
| Searching a cell for a certain character. | Excel Worksheet Functions | |||
| only include cells beginning with specified character or number | Excel Worksheet Functions | |||
Linear Mode
