Hope this is easy

[RobertG]

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.

 

[Gary''s Student]

In C enter the formula:

=A1 & B1

 

[hmsawyer]

I'm pretty sure that =A1&B1 will get you what you need.

 

[RobertG]

Thank you. See I knew it would be easy.

In C enter the formula:

=A1 & B1