How to Extract Only Text from a Cell

How to Extract Text Only from a Cell

How to split text from a cell
how to extract text from numbers in excel
how to extract text from numbers in excel
Excel Functions
how to extract only alphabets from a cell in excel
how to take text from another cell in excel
excel find text in cell
excel find text in cell formula

🛎️ Subscribe To My Channel and Get More Tricks and Tips.

#MsExcelWorld

The Beginner's Guide to Excel Functions

'Formula function for TextOnly

Function TextOnly(ByVal Txt As String) As String
Dim X As Long 'Codebase by Rick Rothstein (MVP - Excel)
For X = 1 To Len(Txt)
' If Mid(Txt, X, 1) Like "*[!0-9]*" Then Mid(Txt, X, 1) = Chr(1) ' Leave only numbers
If Mid(Txt, X, 1) Like "*[!A-Za-z ]*" Then Mid(Txt, X, 1) = Chr(1) ' Leave only letters and spaces
Next
TextOnly = Replace(Txt, Chr(1), "")
End Function