I have two questions:

1. I have number of names in a column. Names are written as First Name space and Surname. (eg. George Washington) How do I split into two columns?. (First name into one cell and Surname into another cell)

2. How do I convert lower case words into uppercase.


Thanks.
- Mahen