Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
labels to list
I have a worksheet that has labels in it. A1 is the first name and last
names of the peaple, A2 has street address, A3 has city, state, zip, and A4 has telephone #, not all of address have a telephone #. Column B:B is empty C1 has first name and last names and column c1,d1,e1,f1,g1 are joined, C2 has street address, c2,d2,e2,f2,g2 are joined. C3 has city, state, zip, c3,d3,e3,f3,g3 are joined. same thing happens with column h-m. so 1 column a:a, columns 2 joined c-g, column 3 joined h-m I would like to take the address with 3 to four lines and turn each one into a row of address. Thank You Gary Reger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list shrinks as you go down column | Excel Discussion (Misc queries) | |||
How do you find the list option in excel on office xp | Excel Worksheet Functions | |||
Drop-down list Populated by a Subset of a larger list | Excel Worksheet Functions | |||
Contact List in Excel - Printing Labels in Word | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |