Excel Trick To SUM Numbers Containing Text How to Sum Numbers in a Cell with Text

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

• #education
• #excel_trick_to_sum_numbers_containing_text
• #how_to_sum_numbers_in_a_cell_with_text
• #sum_numbers_with_cell
• #add_numbers_with_text
• #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
• #index_match_formula
• #excel_logical_formula
• #excel_in_hindi
• #power_bi_in_hindi
• #vba_in_hindi
• #sum_numbers_with_text_in_it_sum_text_and_numbers