Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-26-2012, 11:02 AM
SavvyEd SavvyEd is offline Automatically add something to cells Windows 7 64bit Automatically add something to cells Office 2010 64bit
Novice
Automatically add something to cells
 
Join Date: Jul 2012
Posts: 2
SavvyEd is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 07-26-2012, 11:06 AM
SavvyEd SavvyEd is offline Automatically add something to cells Windows 7 64bit Automatically add something to cells Office 2010 64bit
Novice
Automatically add something to cells
 
Join Date: Jul 2012
Posts: 2
SavvyEd is on a distinguished road
Default

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"
Reply With Quote
  #3  
Old 07-31-2012, 08:54 PM
macropod's Avatar
macropod macropod is offline Automatically add something to cells Windows 7 64bit Automatically add something to cells Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically add something to cells 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft