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.