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.

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.

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.

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.