Dear Experts ,
I need a Help in Excel that the query i have is to Combine 2 Cell value with "/" and to exclude repeated values
example :
cell A1 : I have a Pen to write
Cell B1 : have a Pencil to write
Cell C1 : i have a book to read
output i expected is
Cell D1 : i have a Pen/Pencil to write
Cell E1 or F1 : i have a Book to read
Please help to find a way to combine and to remove the similar words.
I need a Help in Excel that the query i have is to Combine 2 Cell value with "/" and to exclude repeated values
example :
cell A1 : I have a Pen to write
Cell B1 : have a Pencil to write
Cell C1 : i have a book to read
output i expected is
Cell D1 : i have a Pen/Pencil to write
Cell E1 or F1 : i have a Book to read
Please help to find a way to combine and to remove the similar words.