VALUE & SUBSTITUTE Function in Excel | Convert Text to Number

📊 Remove "Rs" from Amounts in Excel Using VALUE & SUBSTITUTE Function

In this video, you'll learn how to remove the "Rs" text from cells and convert the remaining values into numbers using the SUBSTITUTE and VALUE functions in Excel. This method helps you clean data quickly and perform calculations like SUM, AVERAGE, and more without errors.

✅ Remove currency text from cells
✅ Convert text values into numbers
✅ Use VALUE and SUBSTITUTE functions
✅ Calculate totals easily in Excel
✅ Beginner-friendly Excel tutorial

Formula Used:

=VALUE(SUBSTITUTE(A1,"Rs ",""))

👍 Like, Share & Subscribe for more Excel Tips and Tricks!

#Excel #ExcelTips #ExcelFormula #VALUEFunction #SUBSTITUTEFunction #DataCleaning #ExcelTutorial #MicrosoftExcel #ExcelTricks #LearnExcel #Spreadsheet #Office365 #ExcelForBeginners #ProductivityTips #ExcelHacks

Видео VALUE & SUBSTITUTE Function in Excel | Convert Text to Number канала Excel Tips