Prev: Merging reports
Next: Formula returned instead of result
From: RobertG on 18 May 2010 14:04
How do I combine an alpha character from one cell with a numeric value in
another cell and display the result in a 3rd cell like this:

Cell A1 = B
Cell B1 = 2
Cell C1 should equal B2

Not the sum of the cells, just the actual value "B2".

Thanks.
From: Gary''s Student on 18 May 2010 14:09
In C enter the formula:

=A1 & B1
--
Gary''s Student - gsnu201003


"RobertG" wrote:

> How do I combine an alpha character from one cell with a numeric value in
> another cell and display the result in a 3rd cell like this:
>
> Cell A1 = B
> Cell B1 = 2
> Cell C1 should equal B2
>
> Not the sum of the cells, just the actual value "B2".
>
> Thanks.
From: hmsawyer on 18 May 2010 14:11
I'm pretty sure that =A1&B1 will get you what you need.

"RobertG" wrote:

> How do I combine an alpha character from one cell with a numeric value in
> another cell and display the result in a 3rd cell like this:
>
> Cell A1 = B
> Cell B1 = 2
> Cell C1 should equal B2
>
> Not the sum of the cells, just the actual value "B2".
>
> Thanks.
From: RobertG on 18 May 2010 14:13
Thank you. See I knew it would be easy.

"Gary''s Student" wrote:

> In C enter the formula:
>
> =A1 & B1
> --
> Gary''s Student - gsnu201003
>
>
> "RobertG" wrote:
>
> > How do I combine an alpha character from one cell with a numeric value in
> > another cell and display the result in a 3rd cell like this:
> >
> > Cell A1 = B
> > Cell B1 = 2
> > Cell C1 should equal B2
> >
> > Not the sum of the cells, just the actual value "B2".
> >
> > Thanks.
 | 
Pages: 1
Prev: Merging reports
Next: Formula returned instead of result