separate a Capital starting word from a sentence
 

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.

separate a Capital starting word from a sentence
 

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.

separate a Capital starting word from a sentence
 

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 ?

"Bernie Deitrick" wrote:

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.

separate a Capital starting word from a sentence
 

They have space between two words.
Bernie Deitrick solution, solved my problem.
"romelsb" wrote in message
...
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 ?

"Bernie Deitrick" wrote:

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.