Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

how can you sum up a text with numbers

user-image
Question ajoutée par Mostafa Mahmoud Hanafy FMVA Mohamed , Financial Controller , Gsk - Other Locations
Date de publication: 2013/05/04
Ishtiaq K
par Ishtiaq K , Senior Accountant , Best Homes Emirates Gen. Cont. LLC

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
par Mostafa Mahmoud Hanafy FMVA Mohamed , Financial Controller , Gsk - Other Locations

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
par Hojimurod Bakirov , Financial Projects Consultant , London School of Business & Finance

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
par Waleed Tayea CMA CFM , Assistant Finance Manager , Al Sayer Franchising Company W.L.L. - Caribou Coffee

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

إيمان الحسينى محمد عثمان
par إيمان الحسينى محمد عثمان , Manufacturing administration , سالم وزران أبو العطا ( مصنع إندومى )

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

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?