Can't make excel do what i want...

[wolftamer389]

Hello, I am trying to call data from two separate areas to be represented in
one column for recap. I want to call A1 and C1 into the cell to appear as A1
- C1 with no calculations just the data in each cell represented with a dash
in between. Is that possible?

 

[Jacob Skaria]

Do you mean; formula

=A1 & "-" & C1

If this post helps click Yes

 

[wolftamer389]

OMG! Thank you soo much that is exactly what I needed!