Thread: Joins semicolon seperated text in two cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peiling From Mines Peiling From Mines is offline
external usenet poster
  
Posts: 1
Default 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!
Reply With QuoteReply With Quote