Скачать с ютуб Separate Text and Numbers in Excel (4 Easy Ways) в хорошем качестве

Separate Text and Numbers in Excel (4 Easy Ways)

In this video, I will show you four easy ways to separate text and numbers in Excel. The following four methods are covered in the video: 1. Using Flash Fill 2. Using a Formula 3. Using VBA 4, Using Power Query ✅ Download File: https://swiy.io/7TbN ----------------------------------------------------------------------------------- Below are the two VBA codes I have shown in this video: 'Code created by Sumit Bansal from https://trumpexcel.com Function GetNumber(CellRef As String) Dim StringLength As Integer StringLength = Len(CellRef) For i = 1 To StringLength If IsNumeric(Mid(CellRef, i, 1)) Then Result = Result & Mid(CellRef, i, 1) Next i GetNumber = Result End Function 'Code created by Sumit Bansal from https://trumpexcel.com Function GetText(CellRef As String) Dim StringLength As Integer StringLength = Len(CellRef) For i = 1 To StringLength If Not (IsNumeric(Mid(CellRef, i, 1))) Then Result = Result & Mid(CellRef, i, 1) Next i GetText = Result End Function ----------------------------------------------------------------------------------- 00:00 Intro 00:26 Separate Text and Numbers using Flash Fill 03:36 Separate Text and Numbers using Formula 08:03 Separate Text and Numbers using VBA 11:37 Separate Text and Numbers using Power Query ☕ 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