software

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 -gt; cell b terry and cell c sweety brown

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

thanks
=PROPER(LEFT(A1,FIND(quot;,quot;,A1)-1))
=PROPER(RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1)))

--
Kind regards,

Niek Otten

quot;AskExcelquot; gt; wrote in message
...
gt; hi all,
gt;
gt; 1) check a sentence in a cell, when reach comma, move left portion to cell
gt; b
gt; and the balance portion to cell c.
gt; for example,
gt; terry, sweety brown -gt; cell b terry and cell c sweety brown
gt;
gt; 2) i want to make first letter of each word upper case
gt; terry, sweety brown -gt; Terry, Sweety Brown
gt;
gt; thanks
gt;
gt;
Hi Neik....
This will eliminate the leading space realized from the second formula..
=PROPER(RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1)-1))Vaya con Dios,
Chuck, CABGx3quot;Niek Ottenquot; wrote:

gt; =PROPER(LEFT(A1,FIND(quot;,quot;,A1)-1))
gt; =PROPER(RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1)))
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;AskExcelquot; gt; wrote in message
gt; ...
gt; gt; hi all,
gt; gt;
gt; gt; 1) check a sentence in a cell, when reach comma, move left portion to cell
gt; gt; b
gt; gt; and the balance portion to cell c.
gt; gt; for example,
gt; gt; terry, sweety brown -gt; cell b terry and cell c sweety brown
gt; gt;
gt; gt; 2) i want to make first letter of each word upper case
gt; gt; terry, sweety brown -gt; Terry, Sweety Brown
gt; gt;
gt; gt; thanks
gt; gt;
gt; gt;
gt;
gt;
gt;

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

Thanks,

--
Kind regards,

Niek Otten

quot;CLRquot; gt; wrote in message
...
gt; Hi Neik....
gt; This will eliminate the leading space realized from the second formula..
gt; =PROPER(RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1)-1))
gt;
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; =PROPER(LEFT(A1,FIND(quot;,quot;,A1)-1))
gt;gt; =PROPER(RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1)))
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;AskExcelquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; hi all,
gt;gt; gt;
gt;gt; gt; 1) check a sentence in a cell, when reach comma, move left portion to
gt;gt; gt; cell
gt;gt; gt; b
gt;gt; gt; and the balance portion to cell c.
gt;gt; gt; for example,
gt;gt; gt; terry, sweety brown -gt; cell b terry and cell c sweety brown
gt;gt; gt;
gt;gt; gt; 2) i want to make first letter of each word upper case
gt;gt; gt; terry, sweety brown -gt; Terry, Sweety Brown
gt;gt; gt;
gt;gt; gt; thanks
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;