Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Labels into fields
I have inherited a list of lables (8 pages long) and I'd like to put them
into a spreadsheet. Is there a way to take a basic lable that's already got data and convert it into the fields? ie: name, city, state, etc. without having to retype everything? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Labels into fields
Show us a sample of how your data is currently laid out and is it consistent?
Gord Dibben MS Excel MVP On Fri, 11 Jan 2008 11:06:01 -0800, Michelle wrote: I have inherited a list of lables (8 pages long) and I'd like to put them into a spreadsheet. Is there a way to take a basic lable that's already got data and convert it into the fields? ie: name, city, state, etc. without having to retype everything? |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Labels into fields
They are mailing labels set up like:
Bill Gates 1354 Billionaire Blvd. Sharesomewealth, TX. 55555 :o)~ "Gord Dibben" wrote: Show us a sample of how your data is currently laid out and is it consistent? Gord Dibben MS Excel MVP On Fri, 11 Jan 2008 11:06:01 -0800, Michelle wrote: I have inherited a list of lables (8 pages long) and I'd like to put them into a spreadsheet. Is there a way to take a basic lable that's already got data and convert it into the fields? ie: name, city, state, etc. without having to retype everything? |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Labels into fields
A1...Bill Gates
A2...1354 Billionaire Blvd. A3...Sharesomewealth, TX. 55555 And it is consistent down column A? Any blank rows between each set? If no blank rows, in B1 enter =INDEX($A:$A,(ROWS($1:1)-1)*3+COLUMNS($A:B)-1) Copy across to D1. Select B1:D1 and copy down until you get zeros showing up. Copy the range and Paste Special as Values. Select Column D and DataText to ColumnsDelimited By. Checkmark "Comma" and "Other". Enter a period in "Other" and Finish. If a blank row between each set change the formula to =INDEX($A:$A,(ROWS($1:1)-1)*4+COLUMNS($A:B)-1) and drag across to E1 Delete column E because it will have zeros all the way down. Gord On Fri, 11 Jan 2008 11:49:05 -0800, Michelle wrote: They are mailing labels set up like: Bill Gates 1354 Billionaire Blvd. Sharesomewealth, TX. 55555 :o)~ "Gord Dibben" wrote: Show us a sample of how your data is currently laid out and is it consistent? Gord Dibben MS Excel MVP On Fri, 11 Jan 2008 11:06:01 -0800, Michelle wrote: I have inherited a list of lables (8 pages long) and I'd like to put them into a spreadsheet. Is there a way to take a basic lable that's already got data and convert it into the fields? ie: name, city, state, etc. without having to retype everything? |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
Labels into fields
I will try that when I get to work on Monday, thanks so much for your help!
"Gord Dibben" wrote: A1...Bill Gates A2...1354 Billionaire Blvd. A3...Sharesomewealth, TX. 55555 And it is consistent down column A? Any blank rows between each set? If no blank rows, in B1 enter =INDEX($A:$A,(ROWS($1:1)-1)*3+COLUMNS($A:B)-1) Copy across to D1. Select B1:D1 and copy down until you get zeros showing up. Copy the range and Paste Special as Values. Select Column D and DataText to ColumnsDelimited By. Checkmark "Comma" and "Other". Enter a period in "Other" and Finish. If a blank row between each set change the formula to =INDEX($A:$A,(ROWS($1:1)-1)*4+COLUMNS($A:B)-1) and drag across to E1 Delete column E because it will have zeros all the way down. Gord On Fri, 11 Jan 2008 11:49:05 -0800, Michelle wrote: They are mailing labels set up like: Bill Gates 1354 Billionaire Blvd. Sharesomewealth, TX. 55555 :o)~ "Gord Dibben" wrote: Show us a sample of how your data is currently laid out and is it consistent? Gord Dibben MS Excel MVP On Fri, 11 Jan 2008 11:06:01 -0800, Michelle wrote: I have inherited a list of lables (8 pages long) and I'd like to put them into a spreadsheet. Is there a way to take a basic lable that's already got data and convert it into the fields? ie: name, city, state, etc. without having to retype everything? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
How do I take some of my Excel fields and make address labels? | Excel Discussion (Misc queries) |