ask 2 function

A

AskExcel

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
 
C

CLR

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
 
Top