concatenate two formulas

[Halid]

Hello friends,

I want to combine below two formulas:

A1 = James/Bond MR

B1 = LEFT(A1,FIND(" ",A1)-1)
C1 = REPLACE(B1,FIND("/",B1),1," ") and you will get answer "James Bond" in C1.

I want to see "James Bond" result in B1 with using one formula or combine two above formulas.

Regards

Khalid

[TPDave]

Please Login or Register  to view this content.

[Halid]

Many Thanks.