To split numbers from text, select the cell where you want the result (B1). Next, in the Formula bar, type the following formula:
=REGEXREPLACE(A1,”[a-zA-Z]”,””)
How do I split numbers from text in Google Sheets
Lastly, press the Enter key on your keyboard.
REGEXREPLACE function
The number has now been split off from the text.