Trending Text Processing Discussions

How can you sum up a text with numbers‎

Answers:

5

Followers:

2

Views:

216

Vote Count:

0

 

Answer added by  Ishtiaq K, Senior Accountant, Best Homes Emirates Gen. Cont. LLC
11 years ago

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

 

Answer added by  Mostafa Mahmoud Hanafy FMVA Mohamed, Financial Controller, Gsk - Other Locations
11 years ago

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

 

Answer added by  Hojimurod Bakirov, Financial Projects Consultant, London School of Business & Finance
11 years ago

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

 

Answer added by  Waleed Tayea CMA CFM, Assistant Finance Manager, Al Sayer Franchising Company W.L.L. - Caribou Coffee
10 years ago

you have two ways...1- = CONCATENATE(A1;A2)2- = "A1"&"A2"

 

Answer added by  إيمان الحسينى محمد عثمان, Manufacturing administration, سالم وزران أبو العطا ( مصنع إندومى )
11 years ago

If you want to sum numbers you would use sum Function. Such as. =sum(A1:A10)