Joins semicolon seperated text in two cells

  • Thread starter Thread starter Peiling From Mines
  • Start date Start date
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!
 
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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate strings? 4
Syntax for Double Join 3
Need macro that concatenates cells with text 7
Do when a time and date has elapsed 3
Windows Mail erases all of the messages from the source inbox? 1
Seperate text and number to different cells 3
Password Protect A Page 3
Formula 1

Back
Top