This seems like a very basic problem to me and I'm a little embarrassed to have to ask it, but I just can't figure it out or find it anywhere. I'm attempting to display the contents of 2 cells in another separate cell using references, like so "=A1&B1", so if A1 says Chart and B2 says 1, the separate cell will print out "Chart 1" but this doesn't seem to be a correct formula and anything else I've tried hasn't worked. I've tried Googling the problem several times and I haven't found anything. I think I'm missing/forgetting something obvious but I have no idea what. Could someone please help?
Thanks so much!
Bookmarks