How to separate a text in a certain column?

[kingavijit143]

Hi,

I need a help in this spreadsheet: https://docs.google.com/spreadsheets/d/1oMuo868ISusPHuF28E4gci_r1umW2CnpvDIWEaUCHB8

Basically, I want a formula that will help me separate out the headings of each columns (from B1 to H1) beside each rows that has "F" character in each cells.

For example: I want to separate out the text "<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

BHM204" (from E1) and display it in N2 because in row 2 it has one ​

F ​

​

character in cell E2.

​

Kindly let me know if it can be done by a formula.

Thanks.

 

[István Hirsch]

Where do you want to put the headings if there are more Fs in the row?