| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Outer Joins | Excel Discussion (Misc queries) | |||
| Convert column data to semicolon delimited text string | Excel Worksheet Functions | |||
| Importing Comma Seperated Text Please Help ? | Excel Discussion (Misc queries) | |||
| Put all cells in one cell seperated by comma | New Users to Excel | |||
| Converting Excel data into semicolon delimited text file | Excel Discussion (Misc queries) | |||
Linear Mode
