separate a Capital starting word from a sentence

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rasoul Khoshravan - 19 Oct 2006 11:38 GMT

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.

Reply to this Message

Bernie Deitrick - 19 Oct 2006 18:21 GMT

Rasoul,

For a string in cell A1:

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

HTH,
Bernie
MS Excel MVP

>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.

Reply to this Message

romelsb - 21 Oct 2006 00:16 GMT

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,
>
[quoted text clipped - 11 lines]
> > I want to separate the first total capital word from the rest.
> > How can I do this.

Reply to this Message

Rasoul Khoshravan - 25 Oct 2006 18:31 GMT

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

> Mr. Rasoul - try to place a space " " between the first and the second
> word
[quoted text clipped - 16 lines]
>> > I want to separate the first total capital word from the rest.
>> > How can I do this.

Reply to this Message