Joins semicolon seperated text in two cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peiling From Mines - 29 May 2008 21:45 GMT

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!

Reply to this Message

Kevin B - 29 May 2008 22:00 GMT

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

Signature

Kevin Backmann

> Hi,
>
[quoted text clipped - 7 lines]
>
> Many thanks!

Reply to this Message