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)

[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