the function =cell()

[s]

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

[Ian]

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?
--
Ian
--
"s" <[email protected]> wrote in message
news:[email protected]...
> 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

[s]

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

Sara

"Ian" wrote:

> 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?
> --
> Ian
> --
> "s" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>