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
i said sum text with date or number you are talking about number its pretty easy to you sum but my point is how can i sum text with number
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)