Extracting initials in excel

  jaraba 19:04 24 Jul 2010

I have a databse in excel in which the surnames are in one coloumn. I have extrated the initial of the 1st surname to an adjacent coloumm usin a formula but i would like to extract all the initials to that coloumn as well.
I have previously used the left(), right() & mid formula for similar purposes.

  VoG II 19:28 24 Jul 2010

With Fred Scuttle in A1 this returns FS

=LEFT(A1,1)&MID(A1,FIND(" ",A1)+1,1)

Is that what you were looking for?

  jaraba 00:03 25 Jul 2010

Many thanks that exactly what I was looking for.

  jaraba 09:42 25 Jul 2010

Marked this as resolved toooooooooo early.
Formula from VoG works perfectly for multiple surnames but throws up a error when there is only one surname.
Tried various combinations of if statements but couldn't get them to work.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Comment afficher des fichiers cachés sur Mac ?