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.
For example;
They postal codes are in a column
"1234",
"5678",
"9123"
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,
CS
http://chandoo.org/wp/2010/12/07/merge-cells-without-loosing-data/
Easier than writing a macro like I had to once for 2003. :)