Concatenate into one cell?
Posted on 2013-01-23
Hi there, I have a number of zip codes in excel that I need to format to put into a crystal report.
So far, each code has been set up but the values are top to bottom in a column. I need them left to right in one cell.
They postal codes are in a column
But I need them, "1234","5678","9123" in once cell, not multiple. This way I can just copy the cell contents into my crystal report.
Does anyone have an excel trick for this? Any help would be great, I'm not exactly an excel pro!
Thanks very much,