separate a Capital starting word from a sentence

[Rasoul Khoshravan]

I have a sentence in cells of column A.
Sentence starts with a capital word and the next word starts with capital
but the rest is small.
I want to separate the first total capital word from the rest.
How can I do this.

 

[Bernie Deitrick]

Rasoul,

For a string in cell A1:

=LEFT(A1,FIND(" ",A1)-1)
=MID(A1,FIND(" ",A1)+1,LEN(A1))

HTH,
Bernie
MS Excel MVP

 

[Guest]

Mr. Rasoul - try to place a space " " between the first and the second word
of the sentence. Or u can give me what sentence is it ?

 

[Rasoul Khoshravan]

They have space between two words.
Bernie Deitrick solution, solved my problem.