delete duplicate then combine text
Dear Kevin B , many thanks for answer , but i want to do that with a function
that operats automatically and flexible.
"Kevin B" wrote:
Just concatenate each cell value, excluding the duplicate, in cell A6
=A1&", "&A2&", "&A3&", "&A5
--
Kevin Backmann
"gr_jafari" wrote:
I have thoes text in A1:A5 and now want to have that string in A6 , pleas any
help
ColumnA
1 book
2 pencil
3 pen
4 pen
5 book
6 book,pencil,pen
|