Hi people,

I have just joined this forum because I was hoping someone could offer me some help please, I have an Excel worksheet and I need to do some changes on there however I have never really used Excel so I was looking for some help please.

Basically I have two columns in my excel sheet, the first column has the Second name, First Name and the second column has the Date of birth.

Now what I'm after is two columns really, the first column should show the Furst name Second Name (space in between with no Comma) and the Second column should show the First Initial from the first name, the first initial from the second name and then the date of birth.

Is this possible? Please help as I'm really frustrated as I don't know what to do.