the function =cell()

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

s - 16 Mar 2006 13:46 GMT

Is there a way of "picking up" more than a number or a text with the function
=CELL("contents",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

Reply to this Message

Ian - 16 Mar 2006 13:50 GMT

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

=A2&" "&B1&" "&B3

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

Is this what you meant?

Signature

Ian
--

> Is there a way of "picking up" more than a number or a text with the
> function
[quoted text clipped - 5 lines]
> Thanks,
> sara

Reply to this Message

s - 16 Mar 2006 13:59 GMT

yes that is exactly what i mean, thanks a lot.
i will try this!

Sara

> Do you mean to gather the info from 3 locations into 1 cell?
>
[quoted text clipped - 13 lines]
> > Thanks,
> > sara

Reply to this Message