adding letters and numbers to exisiting numbers in worksheet

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
davetoughAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rory ArchibaldConnect With a Mentor Commented:
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
 
Raheman M. AbdulConnect With a Mentor Senior Infrastructure Support Analyst & Systems DeveloperCommented:
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
 
davetoughAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.