Extracting A Specific line from Multiline Excel Cells

[anonymous321]

Hi Everyone,
I have column A in excel where each cell contains "multiline text". Now I want to extract a specific line which contains the word "Phone". How can I do that?

Many Thanks in advance.

Best Regards,

[AliGW]

Please provide some sample data in a workbook.

[anonymous321]

Please provide some sample data in a workbook.

I have attached the sample data in excel workbook in attachment.

[AliGW]

Try this copied down:

=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("Phone:",A1),99),CHAR(10),REPT(" ",99)),99))

[anonymous321]

Try this copied down:

=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("Phone:",A1),99),CHAR(10),REPT(" ",99)),99))

I found small issue with this formula now: When I try to extract that line which contains "Box" then the formula does not perform correctly and displays the partial result. Please test it at your end.

[AliGW]

Thanks for the rep!

Sorry - I have just closed down my laptop for the evening.

[anonymous321]

No Problem.Take it easy. When you are online then please help me about this problem. Have great day

[AliGW]

I imagine someone else will finish this off for you - someone on your side of the pond.

[AliGW]

Tiny tweak needed - remove the colon from the search text:

=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("Phone",A1),99),CHAR(10),REPT(" ",99)),99))

This will not work on any text where the word 'Phone' does not exist as an identifier.