#1
|
|||
|
|||
Automatically add something to cells
I need to add "A" to the end of IDs already filled out in a column.
For example, if I have a column with 1234 2345 5678 etc I need to make them 1234A 2345A 5678A etc Is there a quick way to do this? I have thousands of rows. |
#2
|
|||
|
|||
I actually just figured it out, so I'll post the solution in case anyone else needs it.
I inserted a new column and used this formula: =A1&"A" |
#3
|
||||
|
||||
As simpler way, that can be applied to the data cells without modifying the workbook content, is to apply the following custom number format to the cells:
#\A
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to make cells shift down automatically | iffy | Excel | 7 | 04-15-2013 08:06 AM |
Automatically change the value of one cell so that two other cells become equal | matthew544 | Excel | 5 | 09-18-2011 08:56 AM |
How can I change the colors of cells automatically based on Job Completion? | Learner7 | Excel | 0 | 07-06-2010 10:47 PM |
format cells to automatically place quotes around text | dirtleg | Excel | 1 | 09-16-2008 01:52 PM |
Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |