how can you sum up a text with numbers

Question

Ishtiaq K · Answer

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= Number A2= 1234 A3= Number 1234 (formula =A1& " "&A2)

Mostafa Mahmoud Hanafy FMVA Mohamed · Answer

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

Hojimurod Bakirov · Answer

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&" "&TEXT(A2,"dd/mm/yyyy")

Waleed Tayea CMA CFM · Answer

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

إيمان الحسينى محمد عثمان · Answer

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

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

how can you sum up a text with numbers

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة