Custom Formatting to Concatenate Two Cells

B

Bryon

Hello,

Say:
A1 = 5
A2 = 8

I'd like A2 to display as "5 to 8". I realize that I can set the custom
format to <<"5 to "0>> (without the <<>>), however I'd rather not hard-code
the 5 when it's in the cell above. Does anyone happen to know how to
include the value of a different cell in your cormatting?

Thanks much,
Bryon Eldridge
 
D

Dave Peterson

I don't think you can do it via formatting alone.

But if you can live with text:

=a1 & " to " & a2
 
Top