Split data in column with formula

[thedeadzeds]

Hi Guys,

How can I split the data column into 2 separate columns as per below using formulas rather than using text to columns.

Thanks

Data	Split 1	Split 2
10/11	10	11
1/11	1	11
10/11	10	11
1/11	1	11
1/2	1	2
1/2	1	2
10/11	10	11
10/11	10	11

 

[awoohaw]

try:

=TEXTSPLIT(A2,"/")

Book1
	A	B	C
1	Data	Split 1	Split 2
2	10/11	10	11
3	1/11	1	11
4	10/11	10	11
5	1/11	1	11
6	1/2	1	2
7	1/2	1	2
8	10/11	10	11
9	10/11	10	11
Sheet1

Cell Formulas
Range	Formula
B2:C9	B2	=TEXTSPLIT(A2,"/")
Dynamic array formulas.