In this video, I'll show you how to remove any text from a cell in excel. This is very useful if your number contains a hyphen, dash, dots, or any other text.
The fomula to is =SUBSTITUTE(C3,"−","")
👉More Videos👇
👉Excel Top 68 Ultimate Tips And Tricks - [ Ссылка ]
👉Intermediate Excel Skills, Tips, and Tricks Tutorial - [ Ссылка ]
👉The Beginner's Guide to Excel | Excel Basics Tutorial - [ Ссылка ]
👉Microsoft Excel Short Tutorials - [ Ссылка ]
#BhupinderTube #excel #substitute #howto
Excel remove text from cell keep numbers formula
Теги
How to remove hyphenformula to remove text from numbers in excelhow to remove - in excel with formulaexcel remove text from cell formularemove numbers from cell in excelhow to remove part of text in a cell in excelHow to remove non numeric characters from cells in Excel 2007How do I remove just text from a cell in ExcelHow do I keep only numbers in ExcelHow do I extract text from a cell in Excel with a formula
