Concatenate en masse?

[Guest]

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:
<PartNumber>123456-001</PartNumber>

 

[Guest]

=CONCATENATE(A1,MID(B1,2,10),C1)

 

[Guest]

=A1&B1&C1

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

 

[Ken Wright]

=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
------------------------------­------------------------------­----------------

 

[Ken Wright]

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
------------------------------­------------------------------­----------------

 

[Guest]

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

 

[Ken Wright]

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

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