#Excel split cells by dash how to
Or, manually click and drag to select the sells you wish to contain the split data. This Excel tutorial explains how to use the Excel SPLIT function with syntax and examples. For example, click on the cell A2 with the mouse pointer and enter sign and type the division sign (/) forward slash as B2/C2 and press the enter key, where b is the dividend and c is the divisor which will give you the desired output.