Convert and Format Excel Table into Word Table

biogenie007

New Member
Joined
Jul 27, 2009
Messages
8
Hi,

I have a huge challenge of converting an excel table into a word formatted table something like creating a booklet out of the data from excel table.

I am doing it manually (painstakingly 3+ weeks of formatting) right now by copying the table from html into word and formatting it accordingly.

Would require to compare 2 or 3 plans maintaining similar numbered sections together.

ANY IDEAS HOW TO AUTOMATE THIS PROCESS WOULD BE GREATLY APPRECIATED.

THE ORIGINAL TABLE is a HTML page which looks like the following when copied to excel (have copies sample data-set):

Excel Workbook
ABC
1If you have any questions about this plan's benefits or costs, please contact Health Plan for details.
2SECTION II - SUMMARY OF BENEFITS
3BenefitOriginal MedicareHealth Plan
4IMPORTANT INFORMATION
51 - Premium and Other Important InformationIn 2008 the monthly Part B Premium was $96.40 and will change for 2009 and the yearly Part B deductible amount was $135 and will change for 2009. ORGeneral
6$0 monthly plan premium in addition to your monthly Medicare Part B premium.
7In 2009 the monthly Part B Premium is $___ and the yearly Part B deductible amount is $___.In-Network
8$3,350 in-network out-of-pocket limit.
9If a doctor or supplier does not accept assignment, their costs are often higher, which means you pay more.Not all plan services are covered under the out-of-pocket limit. Contact plan for a detailed list of non-covered services.
102 - Doctor and Hospital ChoiceYou may go to any doctor, specialist or hospital that accepts Medicare.In-Network
11No referral required for network doctors, specialists, and hospitals.
12(For more information, see Emergency - #15 and Urgently Needed Care - #16.)You may have to pay a separate copay for certain doctor office visits.
13SUMMARY OF BENEFITS
14INPATIENT CARE
153 - Inpatient Hospital CareIn 2008 the amounts for each benefit period were: Days 1 - 60: $1024 deductible Days 61 - 90: $256 per day Days 91 - 150: $512 per lifetime reserve day These amounts will change for 2009. ORIn-Network
16For Medicare-covered hospital stays:
17(includes Substance Abuse and Rehabilitation Services)In 2009 the amounts for each benefit period are: Days 1 - 60: $___ deductible Days 61 - 90: $___ per day Days 91 - 150: $___ per lifetime reserve dayDays 1 - 7: $350 copay per day
18Call 1-800-MEDICARE (1-800-633-4227) for information about lifetime reserve days.Days 8 - 90: $0 copay per day
19Lifetime reserve days can only be used once.Plan covers 60 lifetime reserve days. Cost per lifetime reserve day:*
20A "benefit period" starts the day you go into a hospital or skilled nursing facility. It ends when you go for 60 days in a row without hospital or skilled nursing care. If you go into the hospital after one benefit period has ended, a new benefit period begins. You must pay the inpatient hospital deductible for each benefit period. There is no limit to the number of benefit periods you can have.Days 1 - 60: $0 copay per day
21Plan covers 90 days each benefit period.
22Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital.
234 - Inpatient Mental Health CareSame deductible and copay as inpatient hospital care (see "Inpatient Hospital Care" above).In-Network
24For hospital stays:
25190 day lifetime limit in a Psychiatric Hospital.Days 1 - 7: $300 copay per day
26Days 8 - 90: $0 copay per day
27Plan covers 60 lifetime reserve days. Cost per lifetime reserve day:
28Days 1 - 60: $0 copay per day
29You get up to 190 days in a Psychiatric Hospital in a lifetime.
30Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital.
315 - Skilled Nursing FacilityIn 2008 the amounts for each benefit period after at least a 3-day covered hospital stay were: Days 1 - 20: $0 per day Days 21 - 100: $128 per day These amounts will change for 2009. ORGeneral
32Authorizaton rules may apply.
33(in a Medicare-certified skilled nursing facility)In 2009 the amounts for each benefit period after at least a 3-day covered hospital stay are: Days 1 - 20: $___ per day Days 21 - 100: $___ per dayIn-Network
34For SNF stays:
35100 days for each benefit period.Days 1 - 10: $0 copay per day
36A "benefit period" starts the day you go into a hospital or SNF. It ends when you go for 60 days in a row without hospital or skilled nursing care. If you go into the hospital after one benefit period has ended, a new benefit period begins. You must pay the inpatient hospital deductible for each benefit period. There is no limit to the number of benefit periods you can have.Days 11 - 100: $100 copay per day
37Plan covers up to 100 days each benefit period
38No prior hospital stay is required.
Sheet4


THE COMPLETED BOOKLET LOOKS LIKE THE FOLLOWING IN WORD:

Excel Workbook
ABCDE
1BENEFITORIGINAL MEDICAREPLAN1PLAN2PLAN3
2IMPORTANT INFORMATION
31 - Premium and Other Important InformationIn 2008 the monthly Part B Premium was $96.40 and will change for 2009 and the yearly Part B deductible amount was $135 and will change for 2009. ORGeneralGeneralGeneral
4$0 monthly plan premium in addition to your monthly Medicare Part B premium.$0 monthly plan premium in addition to your monthly Medicare Part B premium.$0 monthly plan premium in addition to your monthly Medicare Part B premium.
5In 2009 the monthly Part B Premium is $___ and the yearly Part B deductible amount is $___.
6In-NetworkIn-NetworkIn-Network
7If a doctor or supplier does not accept assignment, their costs are often higher, which means you pay more.$3,350 in-network out-of-pocket limit.$2,500 in-network out-of-pocket limit.$3,350 in-network out-of-pocket limit.
8
9Not all plan services are covered under the out-of-pocket limit. Contact plan for a detailed list of non-covered services.Not all plan services are covered under the out-of-pocket limit. Contact plan for a detailed list of non-covered services.Not all plan services are covered under the out-of-pocket limit. Contact plan for a detailed list of non-covered services.
102 - Doctor and Hospital ChoiceYou may go to any doctor, specialist or hospital that accepts Medicare.In-NetworkIn-NetworkIn-Network
11(For more information, see Emergency - #15 and Urgently Needed Care - #16.)Referral required for network hospitals and specialists (for certain benefits).Referral required for network hospitals and specialists (for certain benefits).No referral required for network doctors, specialists, and hospitals.
12
13You may have to pay a separate copay for certain doctor office visits.You may have to pay a separate copay for certain doctor office visits.You may have to pay a separate copay for certain doctor office visits.
14SUMMARY OF BENEFITS
15INPATIENT CARE
163 - Inpatient Hospital CareIn 2008 the amounts for each benefit period were: Days 1 - 60: $1024 deductible Days 61 - 90: $256 per day Days 91 - 150: $512 per lifetime reserve dayIn-NetworkIn-NetworkIn-Network
17(includes Substance Abuse and Rehabilitation Services)For Medicare-covered hospital stays:For Medicare-covered hospital stays:For Medicare-covered hospital stays:
183 - Inpatient Hospital CareThese amounts will change for 2009. OR In 2009 the amounts for each benefit period are: Days 1 - 60: $___ deductible Days 61 - 90: $___ per day Days 91 - 150: $___ per lifetime reserve dayDays 1 - 10: $175 copay per dayDays 1 - 7: $75 copay per dayDays 1 - 7: $350 copay per day
19(continued)
20Call 1-800-MEDICARE (1-800-633-4227) for information about lifetime reserve days.Days 11 - 90: $0 copay per dayDays 8 - 90: $0 copay per dayDays 8 - 90: $0 copay per day
21
22Lifetime reserve days can only be used once.Plan covers 60 lifetime reserve days. Cost per lifetime reserve day:Plan covers 60 lifetime reserve days. Cost per lifetime reserve day:Plan covers 60 lifetime reserve days. Cost per lifetime reserve day:
23
24A "benefit period" starts the day you go into a hospital or skilled nursing facility. It ends when you go for 60 days in a row without hospital or skilled nursing care. If you go into the hospital after one benefit period has ended, a new benefit period begins. You must pay the inpatient hospital deductible for each benefit period. There is no limit to the number of benefit periods you can have.*Days 1 - 60: $0 copay per dayDays 1 - 60: $0 copay per dayDays 1 - 60: $0 copay per day
25Plan covers 90 days each benefit period.Plan covers 90 days each benefit period.Plan covers 90 days each benefit period.
26
27Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital.Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital.Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital.
284 - Inpatient Mental Health CareSame deductible and copay as inpatient hospital care (see "Inpatient Hospital Care" above).In-NetworkIn-NetworkIn-Network
29For hospital stays:For hospital stays:For hospital stays:
30190 day lifetime limit in a Psychiatric Hospital.
31Days 1 - 10: $175 copay per dayDays 1 - 7: $75 copay per dayDays 1 - 7: $300 copay per day
32
33Days 11 - 90: $0 copay per dayDays 8 - 90: $0 copay per dayDays 8 - 90: $0 copay per day
34
35Plan covers 60 lifetime reserve days. Cost per lifetime reserve day:Plan covers 60 lifetime reserve days. Cost per lifetime reserve day:Plan covers 60 lifetime reserve days. Cost per lifetime reserve day:
36*4 - Inpatient Mental Health CareDays 1 - 60: $0 copay per dayDays 1 - 60: $0 copay per dayDays 1 - 60: $0 copay per day
37(continued)*
38You get up to 190 days in a Psychiatric Hospital in a lifetime.You get up to 190 days in a Psychiatric Hospital in a lifetime.You get up to 190 days in a Psychiatric Hospital in a lifetime.
39
40Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital.Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital.Except in an emergency, your doctor must tell the plan that you are going to be admitted to the hospital.
415 - Skilled Nursing FacilityIn 2008 the amounts for each benefit period after at least a 3-day covered hospital stay were: Days 1 - 20: $0 per day Days 21 - 100: $128 per day These amounts will change for 2009. ORGeneralGeneralGeneral
42(in a Medicare-certified skilled nursing facility)Authorization rules may apply.Authorization rules may apply.Authorization rules may apply.
43In 2009 the amounts for each benefit period after at least a 3-day covered hospital stay are: Days 1 - 20: $___ per day Days 21 - 100: $___ per dayIn-NetworkIn-NetworkIn-Network
44100 days for each benefit period.For SNF stays:For SNF stays:For SNF stays:
45A "benefit period" starts the day you go into a hospital or SNF. It ends when you go for 60 days in a row without hospital or skilled nursing care. If you go into the hospital after one benefit period has ended, a new benefit period begins. You must pay the inpatient hospital deductible for each benefit period. There is no limit to the number of benefit periods you can have.Days 1 - 10: $0 copay per dayDays 1 - 7: $0 copay per dayDays 1 - 10: $0 copay per day
46Days 11 - 100: $100 copay per dayDays 8 - 100: $75 copay per dayDays 11 - 100: $100 copay per day
47
48Plan covers up to 100 days each benefit periodPlan covers up to 100 days each benefit periodPlan covers up to 100 days each benefit period
49No prior hospital stay is requiredNo prior hospital stay is required
50No prior hospital stay is required
51
52
53
54
Sheet5
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,224,521
Messages
6,179,284
Members
452,902
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top