Joins semicolon seperated text in two cells
 

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!

Joins semicolon seperated text in two cells
 

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))
--
Kevin Backmann


"Peiling From Mines" wrote:

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!