I am concatenateing many cell together. Example is Column A has a word " Starter" Column B is the type of tractor it fits " Case" Column C thru E have other names IE John Deere, Ford only if the part fits more than one type of tractor. In my final Concatenate i end up with many comma's and nothing follows. I have placed a ", " in between each reference of the cell. If the cell is 0 or null. I want the concatenate to ignore the cell and extra commas.
My current function reads + Concatenate(A1,", For ",B2,", ",C2,", ",D2,", ",E2)
Any one have any ideas?
What I have now.
Starter, For John Deere, , , , , , , .
Starter, For John Deere, Ford, , , , , , .
What I wish is.
Starter, For John Deere, Ford.
Bookmarks