| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate question | Excel Worksheet Functions | |||
| function to concatenate range | Excel Discussion (Misc queries) | |||
| Concatenate | Excel Discussion (Misc queries) | |||
| Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
Hybrid Mode
