Hi sorry for the brief title I am not sure what it is called that I am after!

OK so I have set up an approval button with a macro linked to it and everything which is working fine. However the macro looks up the username of the authoriser which then shows in say cell A1 as first.lastname format. How do I have another format behind the scenes to actually change this to First LastName format...

so rather than joe.blogs to Joe Blogs.

Also while we are on the subject I want the cell to actually say Joe Blogs 15/01/2015 09:15 in the box to show the exact date and time it was approved also but cannot figure this out in the macro!

HEEEEEELP. As a temporary measure the first query is more of a burden for me as I don't want it showing as joe.blogs as it looks tacky.

Thanks
Alun