Need excel concatenate formula or macro built to concatenate the Long Text data from the array. If creating a macro, have the results be in the first line of the Array data in column E.
Item2 Sort Symbol Long Text
00100-049 1 * CROSS, 1" BLACK PIPE
00100-332 1 * #37416 NORDSTROM 3/8" COMBINATION BUTTON HEAD FITTING & LUBRICANT SCREW
00100-332 2 FOR SIZE C LUBRICANT.
00100-333 1 * #37417 NORDSTROM 1/2" COMBINATION BUTTON HEAD FITTING & LUBRICANT SCREW
00100-333 2 FOR SIZE D LUBRICANT.
The ending result should give the long text for all the lines together in one cell. When concatenating please add a space between the cells. cella &" "& cellb
Bookmarks