Change text to match col B

[Sunline]

Hello all , i was wanting to get a function that can look at col A below and change the text to look like col B .
Thanks .

Excel Workbook
	A	B
1	RING OF FIRE	Ring Of Fire
2	TEMPLE HILLS	Temple Hills
3	JOKERS WILD	Jokers Wild
4	PENTANE	Pentane
5	XCELLENT	Xcellent
6	STAR OF RIO	Star Of Rio
Sheet1

 

[VoG]

Try

=PROPER(A1)

 

[Marcol]

Maybe
=PROPER(A1)

 

[Sunline]

Thank you both .