How to insert a cell's content before specific text in a cell.

[jilaba]

How to insert a text before specific text in a cell.

REf : Attachment

Cell A has names like VICTOR FIRST
Cell B has names like LOUIS FERTINAND
(FIRST is a common word)
IN Cell C, before the word FIRST, I want to add / LOUIS FERTINAND
Resulting C cell should be : VICTOR / LOUIS FERTINAND FIRST

If there is no FIRST in cell A, Resulting C should be VICTOR / LOUIS FERTINAND

How to do this?

[bebo021999]

Try:

Please Login or Register  to view this content.

[jilaba]

Try:

Please Login or Register  to view this content.

Thanks. It works, but brings #value if there is no FIRST in Cell A.
(If there is no FIRST in cell A, Resulting C should be VICTOR / LOUIS FERTINAND)

[bebo021999]

Try:

=REPLACE(A1&" ",IFERROR(SEARCH(" FIRST",A1&" "),SEARCH(" ",A1&" ")),1," / "&B1&" ")

[jilaba]

Try:

=REPLACE(A1&" ",IF" ")

Thanks a lot. It worked fine