First initials

[Steved]

Hello From Steved

I have been asked to do a Project this entails Surname and
first and second Names

Question Surname is in a Column, First And Second name is
in one Column

Surname First and Second Names
Jackson Raymond, James

I would like the result to be Jackson R J in one Column
Please.

Thankyou.

 

[Biff]

Hi Steved!

Here's one way:

=A1&" "&LEFT(B1,1)&" "& MID(B1,FIND(", ",B1)+2,1)

Biff

 

[Steved]

Hello Biff

Thankyou very Much.

-----Original Message-----
Hi Steved!

Here's one way:

=A1&" "&LEFT(B1,1)&" "& MID(B1,FIND(", ",B1)+2,1)

Biff

.

 

[Biff]

You're welcome and thanks for the feedback!

Biff

-----Original Message-----
Hello Biff

Thankyou very Much.

.