Text to columns on result not formula

[bmpreston]

I'm trying to use Text to Columns for a column, and the problem is that the data is actually an index function formula. It's the resultant I need to separate into 2 columns.

Any help?

Thanks

 

[jtakw]

Hi,

I'm not so sure you can actually use Text to Columns if the cells actually contain a formula, I might be wrong.
I think the work around is to use formulas instead, I've included a simple sample below, to customize it to your data, I'll need to see a few rows of your sample data.

Book1
	A	B	C	D	E	F
1	Basket	Ball	Basket Ball		Basket	Ball
Sheet12

Cell Formulas
Range	Formula
C1	=A1&" "&B1
E1	=LEFT(C1,FIND(" ",C1)-1)
F1	=RIGHT(C1,LEN(C1)-LEN(E1)-1)

 

[bmpreston]

I think I can actually text to column the data in the previous table, then parse that data out. Sorry for bothering by trying to do it after the lookup.

Thanks