software

(Excel 2003)
Hi,
I'm trying to find out how to move data with it's headers into one single
cell block?
For example: If I have 3 colomns with headers: Name Surname Age
with data: Mark
Peters 37

How can I move all headers with data to one single cell For example:
Name: Mark, Surname: Peters, Age: 37

Any ideas would be most appreciated,
Regards,
MAC


quot;MACquot; gt; wrote in message
...
gt; (Excel 2003)
gt; Hi,
gt; I'm trying to find out how to move data with it's headers into one single
gt; cell block?
gt; For example: If I have 3 colomns with headers: Name Surname Age
gt; with data: Mark
gt; Peters 37
gt;
gt; How can I move all headers with data to one single cell For example:
gt; Name: Mark, Surname: Peters, Age: 37
gt;
gt; Any ideas would be most appreciated,
gt; Regards,
gt; MAC

Experiment (don't do this on an important sheet until you see what it does):

Insert, Function, choose quot;Allquot;, then in the list on the right, click the
quot;Concatenatequot; function and click next or OK. That function allows you to
create a chunk of text from pieces in other cells. Pretty easy, actually.
Just be sure to put spaces between the various chunks, if necessary. You do
that by enclosing a space in quotes:
quot; quot;

You can also put things like dashes or commas between the quotes.

quot;Doug Kanterquot; gt; wrote in message
...
gt;
gt; quot;MACquot; gt; wrote in message
gt; ...
gt;gt; (Excel 2003)
gt;gt; Hi,
gt;gt; I'm trying to find out how to move data with it's headers into one single
gt;gt; cell block?
gt;gt; For example: If I have 3 colomns with headers: Name Surname Age
gt;gt; with data: Mark
gt;gt; Peters 37
gt;gt;
gt;gt; How can I move all headers with data to one single cell For example:
gt;gt; Name: Mark, Surname: Peters, Age: 37
gt;gt;
gt;gt; Any ideas would be most appreciated,
gt;gt; Regards,
gt;gt; MAC
gt;
gt; Experiment (don't do this on an important sheet until you see what it
gt; does):
gt;
gt; Insert, Function, choose quot;Allquot;, then in the list on the right, click the
gt; quot;Concatenatequot; function and click next or OK. That function allows you to
gt; create a chunk of text from pieces in other cells. Pretty easy, actually.
gt; Just be sure to put spaces between the various chunks, if necessary. You
gt; do that by enclosing a space in quotes:
gt; quot; quot;
gt;
gt; You can also put things like dashes or commas between the quotes.
gt;

Forgot to mention this: In the boxes provided by the Insert Function thing,
you use cell references like A1, D3 to pick up the values of the cells whose
text you want to use.
Well, you could do this with a formula:-

=quot;Name: quot;amp;A2amp;quot;, Surname: quot;amp;B2amp;quot;, Age: quot;amp;C2

but that could change if the original cells are amended. Or with a simple
macro:-

Range(quot;E2quot;).Select
ActiveCell.Value = quot;Name: quot; amp; Range(quot;A2quot;) amp; quot;, Surname: quot; amp; Range(quot;B2quot;)
amp; quot;, Age: quot; amp; Range(quot;C2quot;)

which will end up with the required value

quot;MACquot; wrote:

gt; (Excel 2003)
gt; Hi,
gt; I'm trying to find out how to move data with it's headers into one single
gt; cell block?
gt; For example: If I have 3 colomns with headers: Name Surname Age
gt; with data: Mark
gt; Peters 37
gt;
gt; How can I move all headers with data to one single cell For example:
gt; Name: Mark, Surname: Peters, Age: 37
gt;
gt; Any ideas would be most appreciated,
gt; Regards,
gt; MAC