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: [ Ссылка ]
-----------------------------------------------------------------------------------
Below are the two VBA codes I have shown in this video:
'Code created by Sumit Bansal from [ Ссылка ]
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 [ Ссылка ]
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 - [ Ссылка ]
✅ Free Excel Course (Basic to Advanced) - [ Ссылка ]
✅ Free Dashboard Course - [ Ссылка ]
✅ Free VBA course - [ Ссылка ]
✅ Free Power Query Course - [ Ссылка ]
✅ Best Excel Books: [ Ссылка ]
Subscribe to get awesome Excel Tips every week: [ Ссылка ]
#Excel #ExcelTips #ExcelTutorial
Separate Text and Numbers in Excel (4 Easy Ways)
Теги
Separate text and numbers in ExcelSplit text and numbers in ExcelExtract numbers from textextract numbers from text in excelextract numbers from text string excelseparate numbers and text in ExcelSplit numbers and text in Exceladvanced excelexcelexcel basicsexcel tipsexcel tutorialslearn excelsumit bansaltrump excelseparate numbers and lettersextract numbers from textseparate numbers from text in excel