Custom Formatting to Concatenate Two Cells

  • Thread starter Thread starter Bryon
  • Start date Start date
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
 
I don't think you can do it via formatting alone.

But if you can live with text:

=a1 & " to " & a2
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split concatenation 4
undo concatenated cells 2
undo concatenated cells 1
Conditional Formatting 4
Concatenate 1
concatenate & custom formats 1
CONCATENATE cells if other cells are the same 3
Concatenate 2 different number formats 11

Back
Top