ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't make excel do what i want... (https://www.excelbanter.com/excel-discussion-misc-queries/235744-cant-make-excel-do-what-i-want.html)

wolftamer389

Can't make excel do what i want...
 
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

Can't make excel do what i want...
 
Do you mean; formula

=A1 & "-" & C1

If this post helps click Yes
---------------
Jacob Skaria


"wolftamer389" wrote:

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?


wolftamer389

Can't make excel do what i want...
 
OMG! Thank you soo much that is exactly what I needed!


All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com