First initials

Steved · Jul 9, 2004

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 · Jul 9, 2004

Hi Steved!

Here's one way:

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

Biff

Steved · Jul 9, 2004

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 · Jul 9, 2004

You're welcome and thanks for the feedback!

Biff

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

Thankyou very Much.

.