Ask the Community
Ask any professional question and get answers from other specialists.
In MS Excel if one cell contains text and other number, then they can be added together in 3rd cell by using ampersand sign; and use parenthesis for giving space. A1= Nu ... See More
Let's say A1 = "my date of birth is" A2 = "20/08/1985" so you need a result of in one cell A3 = "my date of birth is 20/08/1985" =A1&am ... See More
you have two ways...1- = CONCATENATE(A1;A2)2- = "A1"&"A2"
If you want to sum numbers you would use sum Function. Such as. =sum(A1:A10)