Formula require to extract the text

[Nisha Dhawan]

Hi All,

I have a text in column A for Ex:-ABC to XYZ and 123, in this text I want to extract the text after to and before and in next column.

Please help me to extract the text as require.

Thanks
Nisha

[udprocks]

Hi Nisha,

Can u please upload a sample file with expected reuslt...?


Best Regards,
Jitendra

[Vikas_Gautam]

Hi,
here is your formula..

Please Login or Register  to view this content.

[Nisha Dhawan]

Hi,

Please find the attached data.

[AlKey]

Try this formula in B1 and copy down

=TRIM(MID(SUBSTITUTE(A2," ",REPT(" ",25)),50,25))

Row\Col	A	B
1	Data	Result
2	ABC to XYZ and 123	XYZ
3	efg to lmn and 456	lmn

[ashishmehra2010]

Hi Nisha,

If you are using Microsoft Excel 2013 then the simple answer is to use Flash Fill feature to get your expected result.

Kindly mark this thread as solved if your query is resolved.

Regards,
AM