JOHN comprises of four letters, the next value is not a text but a number, hence, the position of the first number is 5 We will also input Position, Name, and Date of Birth into Cell B3, Cell C3, and Cell D3 respectively.įigure 2: Setting up the Data The Basic Formula We will set up the data by inserting the Names of five college students in Column A, including their date of birth without leaving a space between the name and the date of birth. The steps below will walk through the process of splitting text and numbers contained in a Cell.įigure 1: Split text and Numbers with a Formula Setting up the Data
We can easily split text and numbers from a cell by using different combinations of functions such as FIND, MIN, LEN, LEFT, and RIGHT functions. How to Split Text and Numbers with a Formula in Excel
