Get values from one cell to different cells without text

[Jyotirmaya]

I have data in Column A, like example 788 to 1247, in B & C Column I want the values 788 and 1247 without the Word "TO" & without any spaces before or after. Kindly help me with the code or formula

 

[jtakw]

Hi,

Would this work for you, results converted to Real Numbers.
If you want a single formula, use B3 formula dragged across:

Book3.xlsx
	A	B	C
1	788 to 1247	788	1247
2	79 TO 12347	79	12347
3	789 To 1247	789	1247
4	80 TO 12347	80	12347
Sheet998

Cell Formulas
Range	Formula
B1:B2	B1	=LEFT(A1,SEARCH("to",A1)-1)+0
C1:C2	C1	=MID(A1,SEARCH("to",A1)+2,99)+0
B3:C4	B3	=MID(SUBSTITUTE(LOWER($A3),"to",REPT(" ",99)),COLUMNS($B3:B3)*99-99+1,99)+0

 

[Jyotirmaya]

Hi,

Would this work for you, results converted to Real Numbers.
If you want a single formula, use B3 formula dragged across:

Book3.xlsx
	A	B	C
1	788 to 1247	788	1247
2	79 TO 12347	79	12347
3	789 To 1247	789	1247
4	80 TO 12347	80	12347
Sheet998

Cell Formulas
Range	Formula
B1:B2	B1	=LEFT(A1,SEARCH("to",A1)-1)+0
C1:C2	C1	=MID(A1,SEARCH("to",A1)+2,99)+0
B3:C4	B3	=MID(SUBSTITUTE(LOWER($A3),"to",REPT(" ",99)),COLUMNS($B3:B3)*99-99+1,99)+0

Thank You

 

[jtakw]

You're welcome.