I'm not sure if this can be done but if I had the numbers 1, 2, 3, 4 and 5 in cells A1, A2, A3, A4 and A5 respectively, is there a formula that I could put in another cell to display "12345"?
I was playing around with the consolidate function, but I couldn't get it to work, and it's not a formula, it is done after the fact.
(PS. I've got no idea about macros)
Thanks in advance
Jase
SEE ATTACHMENT
Bookmarks