The main function we'll be using here is LEFT, which returns the leftmost characters from a cell. What we assume here is that a space separates the number and text, though the method also works for any other delimiter. This method is a bit cumbersome, but works very well on small datasets. Note: Cells formatted as text will not automatically emerge with a number formatting (or vice versa), meaning you might still have to convert these cells as described above.Įxtract a Number or Text From a Delimited String You can even create a number of splits that way.
If you only have one- and two-digit numbers, the Fixed Width option can be useful too, as it will only split off the first two or three characters of the cell.
