Text format

mbancs · Feb 16th, 2002, 06:43 PM

I'm new to excel.
I just got sent 500 address in one long line each. Cell A-Z-AM.
How do I format each line so it reads like an address label( about 5 lines) for my envelopes.
Thanx Moe

laurajean100 · Feb 17th, 2002, 06:10 PM

well, the first thing you probably want to
do is go to Data, Text to Columns
and use the Delineate option to separate
each row of your addresses into its own cell
in excell.

anno · Feb 17th, 2002, 07:23 PM

once you've done what laurajean100 has suggested, select your data, and do a copy and paste special>transpose which will arrange the data as you required

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

Feb 16th, 2002, 06:43 PM	#1
mbancs New Member Join Date: Feb 2002 Location: moez Posts: 1	I'm new to excel. I just got sent 500 address in one long line each. Cell A-Z-AM. How do I format each line so it reads like an address label( about 5 lines) for my envelopes. Thanx Moe

Feb 17th, 2002, 06:10 PM	#2
laurajean100 New Member Join Date: Feb 2002 Posts: 8	well, the first thing you probably want to do is go to Data, Text to Columns and use the Delineate option to separate each row of your addresses into its own cell in excell.

Feb 17th, 2002, 07:23 PM	#3
anno Board Regular Join Date: Feb 2002 Posts: 202	once you've done what laurajean100 has suggested, select your data, and do a copy and paste special>transpose which will arrange the data as you required