formula help

[Anwar Beeharry]

Hi There
I m pretty new to this, I have basic functions down but need some help with putting together the following:

Mr P. Jackson

The Title, Full first Name and surname are all in different cells. I want to concatenate and add a full stop so it reads as above.

so what I am looking for is: Title + first character of first name + full stop + space + Last name.

Can this be done? can anyone help?

Tanks in advance!

 

[Special-K99]

in D1
=A1&" "&left(B1,1)&". "&C1

where data is in columns A to C

 

[VoG]

Try like this

=A1&" "&LEFT(B1,1)&". "&C1

 

[Anwar Beeharry]

Works a treat! Many thanks

 

[Anwar Beeharry]

Brilliant, thank you