Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

adding letters and numbers to exisiting numbers in worksheet

Posted on 2013-05-13
3
Medium Priority
?
210 Views
Last Modified: 2013-05-13
hello,
am attaching worksheet
if you look at column A and then C
is there a way to add SAC to numbers that already exist?
( othere than rewrtiting number)

if  you look at column E and then G
is there a way to add 101 to numbers that already exist?

thank you
Book1.xlsx
0
Comment
Question by:davetough
3 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 1200 total points
ID: 39161581
You can use formulas like
="SAC" & A1

or
="101"&E1

and then copy and paste special-values those over the top of the original data if you need to.
0
 
LVL 19

Assisted Solution

by:Raheman M. Abdul
Raheman M. Abdul earned 800 total points
ID: 39161585
In column C, type the following:


=CONCATENATE("SAC",A8)


In column G type:

=CONCATENATE("101",E8)


Then copy the formula downwards
Copy-of-Book1.xlsx
0
 

Author Closing Comment

by:davetough
ID: 39162448
thank you
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question