Excel Formula

  Leepaci 12:35 25 Feb 08
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 08

have a look at this website.
Fantastic free tutorials.

Hope this helps

  VoG II 12:38 25 Feb 08

Try

=LEFT(A1,1)

copied down.

  2neat 12:38 25 Feb 08

Oops click here

  Leepaci 15:22 25 Feb 08

Thanks for your help!

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

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced