How to Remove Comma in Excel (from Numbers and Text Strings)

Published: 13 August 2020
on channel: TrumpExcel
144,243
1.2k

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


Watch video How to Remove Comma in Excel (from Numbers and Text Strings) online without registration, duration hours minute second in high quality. This video was added by user TrumpExcel 13 August 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 144,243 once and liked it 1.2 thousand people.