hi all,

1) check a sentence in a cell, when reach comma, move left portion to cell b
and the balance portion to cell c.
for example,
terry, sweety brown -> cell b terry and cell c sweety brown

2) i want to make first letter of each word upper case
terry, sweety brown -> Terry, Sweety Brown

thanks

=PROPER(LEFT(A1,FIND(",",A1)-1))
=PROPER(RIGHT(A1,LEN(A1)-FIND(",",A1)))

--
Kind regards,

Niek Otten

"AskExcel" <(E-Mail Removed)> wrote in message
news:2CB07616-8010-4628-B58A-(E-Mail Removed)...
> hi all,
>
> 1) check a sentence in a cell, when reach comma, move left portion to cell
> b
> and the balance portion to cell c.
> for example,
> terry, sweety brown -> cell b terry and cell c sweety brown
>
> 2) i want to make first letter of each word upper case
> terry, sweety brown -> Terry, Sweety Brown
>
> thanks
>
>

Hi Neik....
This will eliminate the leading space realized from the second formula..
=PROPER(RIGHT(A1,LEN(A1)-FIND(",",A1)-1))


Vaya con Dios,
Chuck, CABGx3


"Niek Otten" wrote:

> =PROPER(LEFT(A1,FIND(",",A1)-1))
> =PROPER(RIGHT(A1,LEN(A1)-FIND(",",A1)))
>
> --
> Kind regards,
>
> Niek Otten
>
> "AskExcel" <(E-Mail Removed)> wrote in message
> news:2CB07616-8010-4628-B58A-(E-Mail Removed)...
> > hi all,
> >
> > 1) check a sentence in a cell, when reach comma, move left portion to cell
> > b
> > and the balance portion to cell c.
> > for example,
> > terry, sweety brown -> cell b terry and cell c sweety brown
> >
> > 2) i want to make first letter of each word upper case
> > terry, sweety brown -> Terry, Sweety Brown
> >
> > thanks
> >
> >
>
>
>

You're right! I didn't notice it on my screen so I forgot

Thanks,

--
Kind regards,

Niek Otten

"CLR" <(E-Mail Removed)> wrote in message
news:66EB5072-C0F5-4548-A273-(E-Mail Removed)...
> Hi Neik....
> This will eliminate the leading space realized from the second formula..
> =PROPER(RIGHT(A1,LEN(A1)-FIND(",",A1)-1))
>
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Niek Otten" wrote:
>
>> =PROPER(LEFT(A1,FIND(",",A1)-1))
>> =PROPER(RIGHT(A1,LEN(A1)-FIND(",",A1)))
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "AskExcel" <(E-Mail Removed)> wrote in message
>> news:2CB07616-8010-4628-B58A-(E-Mail Removed)...
>> > hi all,
>> >
>> > 1) check a sentence in a cell, when reach comma, move left portion to
>> > cell
>> > b
>> > and the balance portion to cell c.
>> > for example,
>> > terry, sweety brown -> cell b terry and cell c sweety brown
>> >
>> > 2) i want to make first letter of each word upper case
>> > terry, sweety brown -> Terry, Sweety Brown
>> >
>> > thanks
>> >
>> >
>>
>>
>>