Formatting addresses over columns

Marcus · Apr 4th, 2002, 05:08 AM

Hello chaps,

In column A is an address with lines seperated by commas. In column B is the Postcode. There are approx 3000 records and I need to re-create this in a single column.

Eventually this ends up in MS Word, in a table, each address in a box in the format

line 1,
line 2,
line 3,
county.
postcode

The table is two addresses wide, and 1500 long. Is there a simple way of tidying it sufficiently to make it less labour intensive?

Cheers,
Marcus

Dave Hawley · Apr 4th, 2002, 05:17 AM

Hi Marcus

Not sure how you want the end result, but select Column "A" and try Data>Text to columns

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 05:08 AM	#1
Marcus New Member Join Date: Mar 2002 Location: London, England Posts: 37	Hello chaps, In column A is an address with lines seperated by commas. In column B is the Postcode. There are approx 3000 records and I need to re-create this in a single column. Eventually this ends up in MS Word, in a table, each address in a box in the format line 1, line 2, line 3, county. postcode The table is two addresses wide, and 1500 long. Is there a simple way of tidying it sufficiently to make it less labour intensive? Cheers, Marcus

Apr 4th, 2002, 05:17 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Marcus Not sure how you want the end result, but select Column "A" and try Data>Text to columns