Need Help

[satnair]

Hi,

I have a spreadsheet with multiple columns, in one column i have a text worklog of the activities performed by various consultants, i need to fetch names of specific consultants from the worklog.

Can someone suggest on the formula that could be used to derive this result.

Thanks.

Rgds,

Sat.

[Bob Phillips]

Give us some details of the data format.

[satnair]

Give us some details of the data format.

I have attached a Sample Dat.

Please look .

Thanks.

[Bob Phillips]

I can't see any names in that worklog. For instance, A2 doesn't contain the name in B2.