Excel Formula

  Leepaci 12:35 25 Feb 2008
Locked

Hello, Can anyone help me with this little query? I have a list of names in a column on an Excel worksheet. I would like the cells in another column to pickup just the first initial from the original column. E.g.

Column A Column B
James J
Lee L
Deborah D
Sarah S
Richard R
John J

....and so on.

Thank you in advance for any help.
Lee

  2neat 12:38 25 Feb 2008

have a look at this website.
Fantastic free tutorials.

Hope this helps

  VoG II 12:38 25 Feb 2008

Try

=LEFT(A1,1)

copied down.

  2neat 12:38 25 Feb 2008

Oops click here

  Leepaci 15:22 25 Feb 2008

Thanks for your help!

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?