How to copying text from one column to another

[krishhi]

Hello,

I have a spread sheet, containing four columns. I want to extract some required text from one cell to another specified cell.

For example, I have two rows like 1. function and 2. modifier.

In Modifier the text is like "Function check of the engine".

So, I need the Function Check from the Modifier row and copy to the Function column.

So, in this same way, i have many other terms like, operating, process drain etc.. so, i need to extract the require text from the cell to another.

(please check the Attachment i Clearly mentioned in the Comments)

Is there any way to do this.

[rwgrietveld]

If "OF" is the distingisher than put this in C4

=LEFT(D4,FIND("OF",D4,1)-2)