We help IT Professionals succeed at work.

Combining data in Excel

batman_k
batman_k asked
on
Medium Priority
321 Views
Last Modified: 2012-05-11
I’ve got 2 Excel (Text) data field which I want to combine the output in third one.
Example:

A1=5
A2=6

I would like A3 to become 56…(aka 5+6=56) not 11
Is there any way to add and not to calculate in this regard?

Thanks in advance!
Comment
Watch Question

Engineer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
To keep it numerical use

=--A1&A2
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
If it is always single digit numbers you can also use

=10*A1+A2

Author

Commented:
Astonishing …cant believe myself
Almost rewrote all Excel functions here..Thanks man !!!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.