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

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

Concatenate en masse?
 

=A1&B1&C1

& is essentially the same thing as using the concatenate formula, just easier.

"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

Concatenate en masse?
 

=A1&MID(B1,2,LEN(B1)-2)&C1

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"SDP" wrote in message
...
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

Concatenate en masse?
 

Take a closer look at the final desired string.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Sloth" wrote in message
...
=A1&B1&C1

& is essentially the same thing as using the concatenate formula, just
easier.

"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

Concatenate en masse?
 

Thank you all for the responses.
I used =A1&B1&C1 successfully.
Thanks again,
Sampson

"Ken Wright" wrote:

=A1&MID(B1,2,LEN(B1)-2)&C1

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"SDP" wrote in message
...
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

Concatenate en masse?
 

Even though it doesn't give you the result you posted, or was that result
missing the parenthesis by mistake?

Regards
Ken................

"SDP" wrote in message
...
Thank you all for the responses.
I used =A1&B1&C1 successfully.
Thanks again,
Sampson

"Ken Wright" wrote:

=A1&MID(B1,2,LEN(B1)-2)&C1

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"SDP" wrote in message
...
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