| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't make excel do what i want...
OMG! Thank you soo much that is exactly what I needed!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
| How do I make make comment format default? | Excel Discussion (Misc queries) | |||
| make macros usable! make instructions in plain english !!!! | Excel Worksheet Functions | |||
| Excel templates. Wanna make excel look like regular blue lined pap | Excel Discussion (Misc queries) | |||
| how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
Linear Mode
