Concatenate en masse?
=CONCATENATE(A1,MID(B1,2,10),C1)
"SDP" wrote:
If I have columns A, B, and C, can I concatenate all to one column?
I'm trying to use this method as a way of mass tagging for xml.
Column A = <PartNumber
Column B = <123456-001
Column C = </PartNumber
The one-column result I'm after would be:
<PartNumber123456-001</PartNumber
|