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