#203-How to use VALUE Function in Excel with 3 Examples

In this tutorial, you will learn how to use the VALUE function in excel with 3 Examples. With the Value formula, you can convert a text string that represents numbers into numbers.

************************************** ~:Related Video Links:~ **************************************
Related Video Links:

********************************* ~:Support Our Work Financially:~ *********************************
Project File Type: Free

#Help me to survive on YouTube
If you donate some amount of money it will help me to survive on YouTube and provide services to you like Creating tutorials for you, solving your office works
problems etc.
#I Need Your Help
Join this channel to get access to perks:
**********************************************************
**********************************************************
**********************************************************
**********************************************************

********************************** ~:Join us on Social Media :~ **********************************

******************************************** ~:Hire Me:~ ********************************************
If want me to help you to build Excel-based applications, you can Hire ME!

****************************************** ~:Sponsored:~ ******************************************

******************************************************************************************************

[CarmenGonzalez-lcju]

So well explained!!! Very helpful. Thank you 😊

[kabayanhustler]

=SUM(VALUE(LEFT(G2:G7, FIND(" ", G2:G7))))&" Mangoes"

[kabayanhustler]

Or you can use this:

=SUM(VALUE(TEXTBEFORE(G2:G7, " ")))&" Mangoes"

Enjoy! 🤗💪