software

Is there a way of quot;picking upquot; more than a number or a text with the function
=CELL(quot;contentsquot;,c1)
Lets say I want to pick up a name in column A, the header of column B and a
value in column B.

Thanks,
sara

Do you mean to gather the info from 3 locations into 1 cell?

=A2amp;quot; quot;amp;B1amp;quot; quot;amp;B3

This will put the values (text or numbers) in A2,B1 amp; B3 into one cell as a
string separated by spaces.

Is this what you meant?
--
Ian
--
quot;squot; gt; wrote in message
...
gt; Is there a way of quot;picking upquot; more than a number or a text with the
gt; function
gt; =CELL(quot;contentsquot;,c1)
gt; Lets say I want to pick up a name in column A, the header of column B and
gt; a
gt; value in column B.
gt;
gt; Thanks,
gt; sara
yes that is exactly what i mean, thanks a lot.
i will try this!

Sara

quot;Ianquot; wrote:

gt; Do you mean to gather the info from 3 locations into 1 cell?
gt;
gt; =A2amp;quot; quot;amp;B1amp;quot; quot;amp;B3
gt;
gt; This will put the values (text or numbers) in A2,B1 amp; B3 into one cell as a
gt; string separated by spaces.
gt;
gt; Is this what you meant?
gt; --
gt; Ian
gt; --
gt; quot;squot; gt; wrote in message
gt; ...
gt; gt; Is there a way of quot;picking upquot; more than a number or a text with the
gt; gt; function
gt; gt; =CELL(quot;contentsquot;,c1)
gt; gt; Lets say I want to pick up a name in column A, the header of column B and
gt; gt; a
gt; gt; value in column B.
gt; gt;
gt; gt; Thanks,
gt; gt; sara
gt;
gt;
gt;