View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SDP SDP is offline
external usenet poster
 
Posts: 16
Default Concatenate en masse?

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