Rasoul,

For a string in cell A1:

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

HTH,
Bernie
MS Excel MVP


"Rasoul Khoshravan" wrote in message
...
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.