Format cell text differently

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

Thanks Trevor will try it Monday and get back to you. Perhaps know how I can get the name date and time in 1 cell too?

VBA would be good yes please

Sure - I can do that - where shall I email the file?

Thanks again

Dear Hi,
I think that u better use, In the HOME Tab(Goto Styles then select Format As Table) and select a format which you like, then make use of design tab(banded rows & columns) to format as u require.......

if it works plz respond positively and clik on add reputation

QC Localised TEST2.xlsm

Sorry for the delay. File should now be attached. Basically on the header tab cells 32-36 are formula driven based off another tab. I want the approval buttons to find the user name, date and time (example shown in column I to automatically populate in cells C38 C40 C42. I have managed to start getting approval buttons 2 and 3 to work as a starting point however approval 1 wont play ball!! If possible what I would like at the end of having that is to have within the macro to lock cells C38 C40 and C42 to that date and time so when the spreadsheet is opened in the future these wont change.

Hope this makes sense. Shout if not.

another quicker query (I hope)

I have a massive spreadsheet of data whereby a whole column of codes look like this CPRGMAPS000001B3.

Is there a quick formula I can put it to make the format XXXX_XXXX_XXXXXX_XX

So CPRG_MAPS_000001_B3

Otherwise I have to manually change over 1000 lines....

Thanks however I have noticed 1 problem.... if I need 2 approvals by 2 different people, when the second person approves it overwrites the first person?

OK so how can I lock the time to each individual button?

At the moment, if you click on any of the approval buttons it all states say 12:02 - then in say 2 mins I reclick 1 to test it, and all 3 change to 12:04 when say approver 1 may authorise yesterday, with the second today... etc

ok shall I post this query somewhere else? or if its ok could you provide me with the LEFT, MID, RIGHT codes as I dont know what they are? (sorry)