Consolidate values from multiple cells

**jasonmcbride** · 10-28-2008, 06:01 PM

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

**fhalejr** · 10-28-2008, 06:12 PM

=A1&A2&A3&A4&A5

This will return a text string "12345". If it can be converted to a number and you need to do so;

=1*(A1&A2&A3&A4&A5)

Hope this helps.