Excel Trick To SUM Numbers Containing Text How to Sum Numbers in a Cell with Text
34.6 هزار بار بازدید -
4 سال پیش
-
Excel Trick To SUM Numbers
Excel Trick To SUM Numbers Containing Text How to Sum Numbers in a Cell with Text
Today we will talk about How to sum numbers have text in cell. It is very interesting question in excel which candidate facing in the interview. We will solve this by 3 methods:-
1) Change format
2) Using Substitute + Sum formula
3) Using Sum + Left + Find formula
Please click on the below link to watch out different playlist :-
1) Microsoft Excel Formula in Hindi : shorturl.at/cdmM7
2) Power BI Tutorial for Beginners in Hindi : shorturl.at/cmJT4
3) SQL Tutorial for Beginners in Hindi : shorturl.at/dptvQ
4) Visual Basic (VBA) Tutorial for Beginners in Hindi : shorturl.at/eioD2
5) Vlookup Formula Series in Hindi : shorturl.at/dpzX3
6) Computer Technology : Tutorial for Beginners in Hindi : shorturl.at/fGPRV
7) MIS Interview Questions : shorturl.at/txIX6
excel trick to sum numbers containing text | how to sum numbers in a cell with text | sum numbers with cell | add numbers with cell | excel trick to sum numbers containing text like 10kg 20kg 12 pcs 14 pcs etc in hindi | teach to each | teachtoeach | teach2each | what is power bi | power bi | excel video in hindi
#sumnumbercontaintext #addnumberwithtext #teachtoeach
Today we will talk about How to sum numbers have text in cell. It is very interesting question in excel which candidate facing in the interview. We will solve this by 3 methods:-
1) Change format
2) Using Substitute + Sum formula
3) Using Sum + Left + Find formula
Please click on the below link to watch out different playlist :-
1) Microsoft Excel Formula in Hindi : shorturl.at/cdmM7
2) Power BI Tutorial for Beginners in Hindi : shorturl.at/cmJT4
3) SQL Tutorial for Beginners in Hindi : shorturl.at/dptvQ
4) Visual Basic (VBA) Tutorial for Beginners in Hindi : shorturl.at/eioD2
5) Vlookup Formula Series in Hindi : shorturl.at/dpzX3
6) Computer Technology : Tutorial for Beginners in Hindi : shorturl.at/fGPRV
7) MIS Interview Questions : shorturl.at/txIX6
excel trick to sum numbers containing text | how to sum numbers in a cell with text | sum numbers with cell | add numbers with cell | excel trick to sum numbers containing text like 10kg 20kg 12 pcs 14 pcs etc in hindi | teach to each | teachtoeach | teach2each | what is power bi | power bi | excel video in hindi
#sumnumbercontaintext #addnumberwithtext #teachtoeach
4 سال پیش
در تاریخ 1399/05/04 منتشر شده
است.
34,617
بـار بازدید شده