Excel Formula Help

[timbo343]

I am trying to extract the first Initial from a name and combine it with the surname.

 

So, in A1 i would have Briggs, in B1 would be Joe and in C1 would be J.Briggs, but how do i get the J fron B1?

 

A B C

1 Briggs Joe J.Briggs

 

I know how to bring them together using the Concanate formula.

 

Can anyone help?

 

Thanks

 

Tim

[vikpaw]

 
=LEFT(B1,1)

Edited May 6, 2010 by vikpaw

[timbo343]

Ahhhh

 

Thank You!

[vikpaw]

welcome, and sometimes rather than use concatenate function, it's easier to use the ampersand (&) symbol e.g.

 

 
=left(b1,1)&"."&A1

Edited May 6, 2010 by vikpaw
layout