Formula require to extract the text

**Nisha Dhawan** · 12-13-2014, 04:17 AM

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** · 12-13-2014, 04:26 AM

Hi Nisha,

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

Best Regards,
Jitendra

**Vikas_Gautam** · 12-13-2014, 04:30 AM

Hi,
here is your formula..

Formula:

Please Login or Register  to view this content.

**Nisha Dhawan** · 12-13-2014, 04:31 AM

Hi,

Please find the attached data.

**AlKey** · 12-13-2014, 09:24 AM

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** · 12-19-2014, 07:37 AM

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

Formula require to extract the text

LinkBack

Thread Tools

Rate This Thread

Display

Formula require to extract the text

Re: Formula require to extract the text

Re: Formula require to extract the text

Re: Formula require to extract the text

Re: Formula require to extract the text

Re: Formula require to extract the text

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help require to insert the text in the formula

[SOLVED] Require Formula to extract data to then populate multiple cells

[SOLVED] Require Help - Require Formula for Multiple values in both columns

Require a formula for getting a specific text from the table

Problem with my formula which require variable extract from steam table.

Bookmarks

Bookmarks

Posting Permissions