英文:
Move table from Outlook to Excel without format change
问题
我在这个情况下感到困惑，不知道该如何解决，有人可以帮我吗？我在考虑在Excel中使用VBA，但我不知道如何根据每个项目合并的行数来让H列进行连接。
我看到有人说，如果我将表格从Outlook复制并粘贴到Google表格中，然后再将其从Google表格复制并粘贴到Excel中，就会得到我需要的结果。但很遗憾，我的公司限制了对Google的访问，所以我不知道该怎么做。
我在互联网上搜索了整个上午，但找不到任何与我类似的问题...
如果有人有关于这个问题的想法，那将非常好。
这是我从系统中得到的报告（发送到Outlook）：
这是我将表格从Outlook复制并粘贴到Excel中的样子：
这是我希望它变成的样子：
请参考上述描述。
英文:
I am stuggle on this situation and have no idea how to figure it out, could someone help me on this??
I was thinking about VBA in Excel, but i have no idea how to let Column H to concate according to how many rows been merged in each project.
And i saw that someone shows that if i copy the table from Outlook and paste it in Google Sheet first and then copy it from Google Sheet and paste it to Excel, it will be exactly what i need it to be. But so sad that my company restricted the access to Google, so i have no idea how to do this.
And i searched on the internet for whole morning and i cannot find anyone ask something similar with me...
This would be very good if anyone have idea on this.
This is the report i get from the system (sent to Outlook)
This is how it looks when i copy the table from Outlook and pasted it to Excel
This is what i want to it to be
Please see above description
答案1
得分: 1
修改E:H范围的列对齐方式。
将对齐选项卡的垂直属性设置为居中。
英文:
Modify Alignment for the columns E:H range.
Set the Alignment tab Vertical property to Center
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论