Hi,

I have a column of data from MSProject which has comma seperated values in
one column. I have used the "Text to Columns" feature but now I need to do a
lookup of the 3 columns and select all instances of a particular value.

i.e. the original column data reads

x Builder,Carters Despatch,Carters Delivery
Carters Despatch
Jack Halsey,Hoults Doors,Carters Despatch

Once seperated I need to display all instances of "Carters Despatch"
regardless of the column they are in.

If there is a better approach whoopee, otherwise can someone please let me
know how I so the selection.

Any help appeciated - thanks.