Excel教程延伸：Word中亦有和Excel同样的分列功能，你晓得吗？
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMy46PTZPG4BGLVZJmia20gUXsFwPf9sDbvQoMSXv1g5eib8qB0yGmzXrF32mbySZyVnwPVdUXJUFkQA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;">↑</span></strong></strong><strong style="color: blue;"><span style="color: black;">入群，免费领取全套Excel视频↑ </span></strong></span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">每日</span>一点小技能</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">职场打怪不得怂</strong></p><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMwY0OFSrNT3ia8icQZ7PfJGEujYl6Y6002J6gxSU0S4nfqrNPib5ciciaHb5yxeKr3eBTzkp91cYwss0XA/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">编按：除了Excel，还有<span style="color: black;">那些</span>办公软件，<span style="color: black;">能够</span>实现分列功能呢？今天，小E给<span style="color: black;">大众</span>带来的<span style="color: black;">便是</span>，办公扩展小技能——word实现分列功能，<span style="color: black;">帮忙</span><span style="color: black;">大众</span>在办公中，实现<span style="color: black;">各样</span>软件的互补操作！</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwNo0aic77ia0cpKT6lB5ibxRNveAKaeDXjAqzX3HtMic0TFa0SpaUdm3nQKGoGDkFHufJFhiauy9l9tYQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">嗨，各位小伙伴们，<span style="color: black;">大众</span>好！今天<span style="color: black;">博主</span>跟<span style="color: black;">大众</span>分享一个很实用的Word功能。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">话不多说，先来<span style="color: black;">瞧瞧</span>下图：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/WB8piaYYKYfnNIugvM6QQNrHeBlh8Sic1KccaDaMGYPyGu2WzicU1WvOGky3fLJx5NicmErLkoumiap9eAAJluRhdJg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">有时<span style="color: black;">咱们</span>从系统里面导出来的数据就像上面图中<span style="color: black;">同样</span>，是以逗号（PS:此处是英文半角状态下的逗号）<span style="color: black;">做为</span>分隔符号将数据<span style="color: black;">掰开</span>，<span style="color: black;">此刻</span>需要将其分成三列<span style="color: black;">表示</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">大部分小伙伴们可能最先想到的应该是用Excel的【分列】功能来处理。</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">例如：</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">Step01：</span></strong><span style="color: black;">先把数据复制到Excel中，点击【数据】-【分列】，打开【分列】对话框，<span style="color: black;">选取</span>【分隔符号】之后，点击【下一步】按钮。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">Step02：</span></strong><span style="color: black;"><span style="color: black;">而后</span>勾选【分隔符号】中的【逗号】，点击【完成】按钮<span style="color: black;">就可</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/WB8piaYYKYfnNIugvM6QQNrHeBlh8Sic1KQryibakzsbIVvHRdISnFZ6GGKUlicWyt3MUfMicw7mdBcfeKRicSdSrgHQ/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">操作起来还是挺简单的吧！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">然则</span>，你若学会用Word中的“分列”功能，会<span style="color: black;">发掘</span><span style="color: black;">一样</span>简单快捷，<span style="color: black;">一块</span>来看一下吧！</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">操作<span style="color: black;">办法</span>：</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">Step01：</span></strong><span style="color: black;">把数据复制到Word中，并<span style="color: black;">所有</span>选中，点击【表格】-【文本转换成表格】。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">Step02：</span></strong><span style="color: black;">打开【将文字转换成表格】对话框，此时，【文字分隔位置】-【逗号】会自动被选中，行、列数<span style="color: black;">亦</span>会自动<span style="color: black;">表示</span>，只需点击【确定】按钮<span style="color: black;">就可</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/WB8piaYYKYfnNIugvM6QQNrHeBlh8Sic1K0yPEJoT7EnTjR7iawSAshuWrY5bzZ9wIc0qoAgO6Yicp0wkLWzJaCswg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">技巧提示：</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1. Word中的这个“分列”功能是不是更快捷呢？它能自动识别段落标记、逗号、空格、制表符这四类分隔符号，而Excel却需要手动勾选<span style="color: black;">或</span>输入。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2. 除了Word默认的分隔符号（段落标记、逗号、空格、制表符）之外，<span style="color: black;">咱们</span>还<span style="color: black;">能够</span>手动在【其他字符】中输入其他的分隔字符。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/WB8piaYYKYfnNIugvM6QQNrHeBlh8Sic1KxV3IH6uprsvb3PAcZuc4vSplfwnlFMmmicJM3L3MHnMqs92j7fYiag8A/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">拓展知识：</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">例1：</span></strong></span><span style="color: black;">有时候，数据之间不<span style="color: black;">必定</span>都是英文状态下的标点符号，<span style="color: black;">亦</span>可能是用中文的标点符号<span style="color: black;">做为</span>分隔符号，如下图所示<span style="color: black;">运用</span>了中文的顿号<span style="color: black;">做为</span>分隔数据的符号。</span></p><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/WB8piaYYKYfnNIugvM6QQNrHeBlh8Sic1Kia9od1MVOsBfE4ZYzZfl2m0o2o6YBgIvSxI6eRj5R3icU75WM42KEeUA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此时，<span style="color: black;">倘若</span><span style="color: black;">咱们</span>用Word“分列”功能中的“其他字符”来<span style="color: black;">实验</span>，会得到什么结果？</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">你会<span style="color: black;">发掘</span>，在“其他字符”文本框中无论你怎么敲敲敲，<span style="color: black;">这儿</span>的中文顿号<span style="color: black;">亦</span>是输入不了的。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/WB8piaYYKYfnNIugvM6QQNrHeBlh8Sic1KdhXw8EJlfUU3LpLLbccG79R2d9fHNfib4elcA06yCJLQTKibst0QvYEQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">为何</span>呢？<span style="color: black;">原由</span>是：<span style="color: black;">这儿</span>的【其他字符】输入框中只能输入英文半角状态下的标点符号，<span style="color: black;">针对</span>中文的标点符号它只能说：臣妾做不到。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">晓得</span><span style="color: black;">原由</span>了，<span style="color: black;">那样</span><span style="color: black;">咱们</span>看下<span style="color: black;">怎样</span><span style="color: black;">处理</span>？</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">处理</span><span style="color: black;">办法</span>01：<span style="color: black;">查询</span>替换法</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">将中文的顿号替换为英文的标点符号<span style="color: black;">就可</span>。<span style="color: black;">例如</span>，<span style="color: black;">咱们</span><span style="color: black;">这儿</span>利用【<span style="color: black;">查询</span>和替换】功能批量将中文的顿号替换为英文的逗号，替换完之后，就<span style="color: black;">能够</span>用上面的<span style="color: black;">办法</span>来进行分列了。</span></p><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/WB8piaYYKYfnNIugvM6QQNrHeBlh8Sic1Ky8GFoeIBaS2xhiabaOg6M3EFIsgKajTUiaehOz8o4DBYz0AwU1dd9jWA/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">处理</span><span style="color: black;">办法</span>02：复制粘贴法</span></strong></span><span style="color: black;">先按【Ctrl+C】复制中文的顿号，<span style="color: black;">而后</span>打开【将文字转换成表格】对话框，将其【Ctrl+V】粘贴到【其他字符】输入框中。</span><span style="color: black;"><span style="color: black;">能够</span>看到，<span style="color: black;">此刻</span>真的<span style="color: black;">能够</span>把中文的顿号给变相的输入进去了，最后点击“确定”按钮，<span style="color: black;">就可</span>完<span style="color: black;">成份</span>列。</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/WB8piaYYKYfnNIugvM6QQNrHeBlh8Sic1KZlYVbMSKZhQkYW9lzZ1QYbEJxwwcWRHUHDgpVOiczaGOXphicxmibqZpQ/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">例2：</span></strong></span><span style="color: black;">有时候，<span style="color: black;">倘若</span>银行名<span style="color: black;">叫作</span>和账户连在<span style="color: black;">一块</span>，数据之间<span style="color: black;">无</span>任何分隔符号。<span style="color: black;">此刻</span>需要将银行名<span style="color: black;">叫作</span>和账户区<span style="color: black;">掰开</span>，你会怎么做呢？</span><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/WB8piaYYKYfnNIugvM6QQNrHeBlh8Sic1KUNH58gnicKuSgI4aCxAktu7wibpERm6rrXv6wZpJ5gnFDicKkFMEzp4FQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;">倘若</span>直接在【其他字符】文本框中输入中文汉字，<span style="color: black;">例如</span>“行”，会<span style="color: black;">发掘</span><span style="color: black;">亦</span>是<span style="color: black;">不可</span>输入的。<span style="color: black;">因此呢</span>，<span style="color: black;">能够</span>得出<span style="color: black;">这般</span>一个结论：中文汉字<span style="color: black;">一样</span><span style="color: black;">没法</span>直接输入。</span><span style="color: black;"><span style="color: black;">咱们</span>还是<span style="color: black;">能够</span>利用【复制粘贴法】来实现目的。</span><span style="color: black;">按【Ctrl+C】复制“行”（<span style="color: black;">这儿</span>每一行最后一个字都是行，<span style="color: black;">因此</span><span style="color: black;">咱们</span>用“行”<span style="color: black;">做为</span>分隔符号），<span style="color: black;">而后</span>【Ctrl+V】直接粘贴到【其他字符】文本框中，<span style="color: black;">而后</span>点击【确定】按钮<span style="color: black;">就可</span>。</span><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/WB8piaYYKYfnNIugvM6QQNrHeBlh8Sic1KsAUn9ygNggQticXqXK0h6V0y6YwEbpmcNyjhP3fK3BrRkOaQkDYRmuA/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;">PS：看到<span style="color: black;">这儿</span>，小伙伴们可能会有2个疑问？</span></strong><span style="color: black;">一是，“行”字<span style="color: black;">因为</span>进行了分列，<span style="color: black;">因此</span>消失了，怎么办？</span><span style="color: black;">二是，<span style="color: black;">倘若</span>文字间的最后一个汉字不相同，又该怎么办？</span><span style="color: black;"><span style="color: black;">处理</span><span style="color: black;">办法</span>很简单，<span style="color: black;">咱们</span><span style="color: black;">能够</span><span style="color: black;">运用</span>【<span style="color: black;">查询</span>和替换】一键批量补齐（或<span style="color: black;">弥补</span>上）相同文字，就<span style="color: black;">能够</span>完美<span style="color: black;">处理</span><span style="color: black;">以上</span>问题啦！而关于【<span style="color: black;">查询</span>和替换】的<span style="color: black;">更加多</span><span style="color: black;">运用</span><span style="color: black;">办法</span>，小伙伴们<span style="color: black;">能够</span>在咱们的公众号上搜索<span style="color: black;">关联</span><span style="color: black;">文案</span>阅读学习。</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">博主</span>编后语：</span></strong></span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1.</span><span style="color: black;">Word【分列】功能被<span style="color: black;">隐匿</span>在【文本转换成表格】功能里面。</span></p><span style="color: black;">2. Word【分列】中的分隔符号不仅支持英文标点符号，<span style="color: black;">况且</span>还支持中文标点符号与中文汉字，只<span style="color: black;">不外</span><span style="color: black;">不可</span>直接手动输入，而是<span style="color: black;">经过</span>复制粘贴的<span style="color: black;">办法</span>输入。</span><span style="color: black;">3. 利用【文本转换成表格】功能，不仅<span style="color: black;">能够</span>分列文本，还有<span style="color: black;">有些</span>其他非常实用的功能。<span style="color: black;">例如</span>，隔行整理数据、隔行删除数据等，<span style="color: black;">大众</span><span style="color: black;">能够</span>尝试下。<span style="color: black;">咱们</span>将在以后的<span style="color: black;">文案</span>中与<span style="color: black;">大众</span><span style="color: black;">一块</span>分享学习。当然，你<span style="color: black;">亦</span><span style="color: black;">能够</span>加入<span style="color: black;">咱们</span>的学习群<span style="color: black;">一块</span>学习交流噢！</span><span style="color: black;">好了，今天的分享就到<span style="color: black;">这儿</span>！我是明镜在心，<span style="color: black;">咱们</span>下次再见！</span><span style="color: black;">觉得赞的小伙伴们欢迎点</span><span style="color: black;">♥</span><span style="color: black;">在看</span><span style="color: black;">♥</span><span style="color: black;">转发</span><span style="color: black;">♥</span><span style="color: black;">留言 呀！么么哒~</span>扫一扫添加老师<span style="color: black;">微X</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxQ9pBIatL1ibJlCLo0nVJm4qoSaeaTzVBkrNicUM6YzgFAcbWavRhkE5MBL5UfAWancWibQxibml2hxg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">扫一扫，在线咨询Excel课程</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/b96CibCt70iabwjyojLhA03PtxUnkNPREnYMIXQoTgtW6libdMibQVNic3eZhU08VyWfSQWdI82zIYSzSTq4Y3YV9nQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">Excel教程<span style="color: black;">关联</span><span style="color: black;">举荐</span></strong></p><a style="color: black;"><span style="color: black;">连这些最<span style="color: black;">基本</span>的函数你都玩不转，就别问<span style="color: black;">为何</span>工资<span style="color: black;">那样</span>低了！</span></a><a style="color: black;"><span style="color: black;"><span style="color: black;">为何</span><span style="color: black;">意见</span>你用Excel数据透视表做<span style="color: black;">报告</span>？这是我见过最好的答案！</span></a><a style="color: black;"><span style="color: black;">别再粘！粘！粘！Excel总表拆分表2分钟搞定！99%人不<span style="color: black;">晓得</span>的新技巧！</span></a><a style="color: black;"><span style="color: black;">Excel训练营 | 0元学Excel，还能免费领<span style="color: black;">海量</span>资源包！限时福利！</span></a>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwSg7uowzyGFN2WC4XOicubfFnyCxXkicg7XJN8Geq4e7gRhFDp814e9T3zn9TcmibqHUCODJ8ibl5W1w/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
页:
[1]