Suite for Excel. Download and free trial Now! The output of these functions is always text. When splitting cells in, excel, the key is to locate the position of the delimiter within the text string. When it comes to extracting part of a text string of a given length, Excel provides three, substring functions (Left, Right and Mid) to quickly handle the task. If you are curious to give it a try, here's the trial version to download. To extract text : left(A2, B2-1) To extract number : right(B2, LEN(A1)-B21) Where A2 is the original string, and B2 is the position of the first number. To extract the color (all characters between the 1st and 2nd hyphens enter the following formula in C2, and then copy it down to other cells: MID(A2, search - A2) 1, search - A2,search - A2)1). Enter key, then drag autofill handle down to apply this formula to cells. Count by Colors, Paging Subtotals, Advanced Sort and Super Filter, More Select/Insert/Delete/ Text Tools. Extract characters from left, select a blank cell next to the text string, and enter this formula left(A1,3 and press. Depending on whether you want the results to be formulas or values, select the Insert as formula box or leave it unselected (default). In the above formula, the text is extracted from cell A2, and the other 2 arguments are calculated by using 4 different search functions: Start number (start_num) is the position of the first hyphen 1: search - A2) 1 Number. A comma and a space, then supply only the comma to the search function, and use 2 and -2 instead of 1 and -1. Start_num - the position of the first character to extract. In case you plan to remove the source data at a later point then do not select this box. Splitting text from one cell into several cells is the task all.