| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Concatenation issue - Help, PLEASE!
A co-worker is having concatenation issues. There are 2 workbooks he is
working with. Book 1-Sheet 1 A10-A12= individual lines of data which need to be "combined into... Book 2-Sheet 1 in cell A10 Please correct me if I am wrong. In Book2 Sheet1 cell A10, he should put the following... =CONCATENATE([Book1]Sheet1!$A$10,[Book1]Sheet1!$A$11,[Book1]Sheet1!$A$12) On a test workbook at my workstation, it works fine, however, when I demonstrated this to a co-worker, he attempted, and text shows for a brief second, then disappears and the formula still shows in the formula bar?? All suggestions are welcome! TIA, Sandi |
|
#3
|
|||
|
|||
|
Concatenation issue - Help, PLEASE!
Are A10, A11, A12 in sheet1 of Book1 empty?
RUSH2CROCHET wrote: A co-worker is having concatenation issues. There are 2 workbooks he is working with. Book 1-Sheet 1 A10-A12= individual lines of data which need to be "combined into... Book 2-Sheet 1 in cell A10 Please correct me if I am wrong. In Book2 Sheet1 cell A10, he should put the following... =CONCATENATE([Book1]Sheet1!$A$10,[Book1]Sheet1!$A$11,[Book1]Sheet1!$A$12) On a test workbook at my workstation, it works fine, however, when I demonstrated this to a co-worker, he attempted, and text shows for a brief second, then disappears and the formula still shows in the formula bar?? All suggestions are welcome! TIA, Sandi -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another rounding issue | Excel Worksheet Functions | |||
| Sorting Issue (Mixde Fields) | Excel Discussion (Misc queries) | |||
| New Excel Comment Box Issue | Excel Discussion (Misc queries) | |||
| Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Linear Mode
