In this video, I will show you how easily remove commas from numbers and from text strings in Excel.
Download Example File: https://bit.ly/3iu4JGW
The following techniques are covered in this video:
00:00 Intro
00:09 - Remove comma from numbers using Number Formatting
01:19 - Remove comma from numbers using NumberValue Formula
02:47 - Remove comma from Text using Find and Replace
03:49 - Remove comma from Text using SUBSTITUTE Function
05:23 - Remove comma from Text using Flash Fill
Based on how your data is structured, you can use any of the above methods to delete commas in Excel.
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial