Extract from particular word to end

[DeepakS]

*All Roles*: = mslabs (Mail Group); Application Main: High Performance Lab= mshpl-team (Mail Group); Server Support Main: = unixops-na (Mail Group); Validator: = mslabs (Mail Group)

how to extract from a particular word to end in a cell. example,

from "Validator:" to "(Mail Group)"

 

[Jonmo1]

Welcome to the board...

Try

=MID(A1,SEARCH("Validator:",A1),LEN(A1))


Change SEARCH to FIND if you want it to be case sensitive looking for "Validator:"

 

[DeepakS]

Thanks a lot its working..