Trending Text Processing Discussions

Follow

Ask the Community


Ask any professional question and get answers from other specialists.

Stream language
Mostafa Mahmoud Hanafy FMVA Mohamed's image
Question added by Mostafa Mahmoud Hanafy FMVA Mohamed Financial Controller Reckit
11 years ago
Answers:
5
Followers:
Views:
216
Vote Count:
0
Answer should contain a minimum of 25 characters.
Ishtiaq K's image  
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

Mostafa Mahmoud Hanafy FMVA Mohamed's image  
Answer added by  Mostafa Mahmoud Hanafy FMVA Mohamed, Financial Controller , Reckit
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

Hojimurod Bakirov's image  
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

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

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

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

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