Formula to find data within a cell 1

[robcarr]

Hi,

I have this contents in a cell.

Organization: Exe Support (Filtered by " Exeter All ")

I use this formula to get the data

=IF(ISERROR(TRIM(MID(C1141,FIND("Exe",C1141),FIND("(",C1141)-2-FIND("Exe",C1141)))),"",TRIM(MID(C1141,FIND("Exe",C1141),FIND("(",C1141)-2-FIND("Exe",C1141))))

this works fine if the organisation begins or contains Exe

however the powers that be have changed the naming convention and I all i need to do is extract the name after the word organization: and the spaces upto the (Filtered by " Exeter All ") part.

Cant figure it out any help


Hope this is of use, Rob.

 

[macropod]

Hi robcarr,

Try:

=IF(ISERROR(TRIM(MID(C1141,FIND(":",C1141)+1,FIND("(",C1141)-1-FIND(":",C1141)))),"",TRIM(MID(C1141,FIND(":",C1141)+1,FIND("(",C1141)-1-FIND(":",C1141))))

Cheers

[MS MVP - Word]

 

[robcarr]

thansk for sorting works a treat

Hope this is of use, Rob.