Macro to Merge Excel Cells within Word Table Borders.
£10-20 GBP
Paid on delivery
I have copied a table created in the Microsoft Word to an Excel spreadsheet because I want to use the facilities of Excel to analyse, group and filter, etc. However, of course, each paragraph mark in Word transfers the text into a new row in Excel. So, for example, a single cell in the Word table could have:-
Jo Smith
1 Street
Anytown
and when copied into Excel as part of the table, breaks into three separate items above each other in three rows of the Excel worksheet. That is:-
Row 1: Jo Smith
Row 2: 1 Street
Row 3: Anytown
The results of the table pasted into the Excel worksheet is in the attachment to this project.
I would like a macro/VBA which I can run any time I place a similar table from Word into an Excel spreadsheet. The macro should identify individual Word table cell contents pasted into excel and arrange them into one excel cell using the paragraph marks from the Word table to determine which text should be placed below the rest of the text within the cell. So, the final arrangement of the Excel cell should be the same as the original table cell in Word. Using the example previously it would look like this:-
Jo Smith
1 Street
Anytown
all with in one cell in Excel.
I hope my description is clear but if you have any questions please do ask.
Thanks,
John
I have uploaded a sample word doc.
John
Project ID: #22045298
About the project
Awarded to:
Greetings! I have reviewed the attachment and understand the requirements. Basically, you would like one to one correspondence between the table in Word and Excel. If the WORD table size is 4*5 then Excel table should More
7 freelancers are bidding on average £25 for this job
Hi, I can code an Excel VBA macro where you will first select the Word File containing the Table, and click a button to copy that table into Excel. But it suppose that we have inly the table in the Word doc. If you wan More
Hello dear sir! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirL More
Dear I read your description and I have found that your job very interesting And it would be easy to be done at a short time you can see my work in the profile --------------------------------------------------- More