Merging Cells
David
The UDF I posted will give you comma-delimited postal codes.
To do it without the UDF
=A1&","&B1&","&C1&","&D1 etc.
Gord
On Thu, 31 Aug 2006 23:16:01 +0100, "David" wrote:
I forgot to mention...the postcodes need to be comma delimted.
"David" wrote in message
...
Hi
I have a list of a couple of thousand postcodes in a column in a
spreadsheet. Each postcode occupies its own cell. Examples of each
postcode might be AB10 or AB11 or AB12 etc. I want to cut and paste these
postcodes to another sheet, many codes to be pasted into single cells.
I tried to merge the cells as they stand so that I could collectively copy
and paste them but excel says that the cells contain multiple data values
and won;t let me merge them.
Can anyone tell me how to do this without cutting and pasting the contents
of each cell, one at a time please?
Many thanks
Dave
|