Joins semicolon seperated text in two cells

P

Peiling From Mines

Hi,

I have:

A1 - "David; Michael"
B1 - "Daddy; Mommy"

How could I get "David loves Daddy; David loves Mommy; Michael loves Daddy;
Michael loves Mommy" in C1?

Many thanks!
 
K

Kevin B

This gets you half of the requested information and you can use it to figure
out the second half:

=LEFT(A1,FIND(";",A1,1)-1)&" loves "&LEFT(B1,FIND(";",B1,1)-1)&"
"&LEFT(A1,FIND(";",A1,1)-1)&" loves "&RIGHT(B1,LEN(B1)-(FIND(";",B1,1)+1))
 
Top