Posted to microsoft.public.excel.misc

SDP

external usenet poster

Posts: 16

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenate question	nick	Excel Worksheet Functions	3	July 27th 06 11:40 PM
function to concatenate range	GoBobbyGo	Excel Discussion (Misc queries)	2	April 19th 06 01:34 AM
Concatenate	Jeff	Excel Discussion (Misc queries)	4	October 5th 05 04:39 PM
Using Concatenate inside a vlookup	bmclean	Excel Worksheet Functions	3	July 5th 05 09:29 PM
Concatenate cells without specifying/writing cell address individually	Hari	Excel Discussion (Misc queries)	4	January 3rd 05 06:05 PM

All times are GMT +1. The time now is 10:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us