Remove the first word of every sentence in a cell

[BFLO2000]

Hello,

For the sentence: "A map is a visual representation . The work of a map is to illustrate geography."

I know that the formula "=RIGHT(B2,LEN(B2)-FIND(" ",B2))" will remove the first letter in the string.

Leaving "map is a visual representation . The work of a map is to illustrate geography."

How would I remove the first word of each sentence?

The output would look like " map is a visual representation . work of a map is to illustrate geography."

Thanks

 

[DanteAmor]

I did say that I was "stretching" things by asking about question marks, exclamation marks, etc.; but the OP does need to come back and tell us one way or the other whether his sentences always end with a period or not

Agreed... which is why I posted the code that I did.

According to everything Rick!