英文:
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
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论