Concatenate en masse?

S

SDP

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

Sloth

=A1&B1&C1

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

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 :)
------------------------------­------------------------------­----------------
 
K

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 :)
------------------------------­------------------------------­----------------
 
S

SDP

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

Ken Wright

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

Regards
Ken................
 
Top