}},"imageContentData":[{"title":"点击数据","num":"1","image":"https://gimg3.baidu.com/topone/src=https://exp-picture.cdn.bcebos.com/32fe25ef354f50b8879fe16cdc4afa32929c1838.jpg&refer=http://www.baidu.com&app=2011&size=w931&n=0&g=0n&er=404&q=100&fmt=auto&maxorilen2heic=2000000?sec=1692637200&t=16b18e0c9b1656d06f1af6f8cd403085","gif":"","content":"打开Excel表格,点击上方的数据。","text":"打开Excel表格,点击上方的数据。","show":"https://exp-picture.cdn.bcebos.com/32fe25ef354f50b8879fe16cdc4afa32929c1838.jpg"},{"title":"点击分列","num":"2","image":"https://gimg3.baidu.com/topone/src=https://exp-picture.cdn.bcebos.com/460fdc8333bf3bef04ee190f3f3ea8db5a1a38.jpg&refer=http://www.baidu.com&app=2011&size=w931&n=0&g=0n&er=404&q=100&fmt=auto&maxorilen2heic=2000000?sec=1692637200&t=0b9e0e0bea78866f74e836f8f78dbbd0","gif":"","content":"在数据界面,点击分列功能。","text":"在数据界面,点击分列功能。","show":"https://exp-picture.cdn.bcebos.com/460fdc8333bf3bef04ee190f3f3ea8db5a1a38.jpg"},{"title":"点击下一步","num":"3","image":"https://gimg3.baidu.com/topone/src=https://exp-picture.cdn.bcebos.com/c3c22dbf3bef354f6219fd8923db574afb321b38.jpg&refer=http://www.baidu.com&app=2011&size=w931&n=0&g=0n&er=404&q=100&fmt=auto&maxorilen2heic=2000000?sec=1692637200&t=f8f1e99b039410ba1ee0fc1a032563c6","gif":"","content":"进入分列里面,点击下一步操作即可。","text":"进入分列里面,点击下一步操作即可。","show":"https://exp-picture.cdn.bcebos.com/c3c22dbf3bef354f6219fd8923db574afb321b38.jpg"}],"consultData":{"btnText":"咨询","img":"https://gips0.baidu.com/it/u=21139722,2187160618&fm=3012&app=3012&autime=1689784548&size=b360,360","name":"fia工作室","url":"https://activity.baidu.com/mbox/4a83aa9f/matrixShareSimple?payAskIMExp=1&fr=pay_zd_searchdqa_assign&trfsr=bdappdqa&uk=403b4069236f25705e79fba2&cate=3CIT&resourceId=302&searchId=10743554539379830353&query=excel+%E5%A6%82%E4%BD%95%E6%8A%8A%E4%B8%80%E4%B8%AA%E5%8D%95%E5%85%83%E6%A0%BC%E7%9A%84%E5%86%85%E5%AE%B9%E5%88%86%E5%BC%80","introduction":"已帮助6372人 1对1咨询","score":"4.5分","isFeedback":true,"dataModule":"direct_person_b","urlParams":{"type":"tc","tcUrl":"https://m.baidu.com/from=844b/bd_page_type=1/ssid=0/uid=0/pu=usm%403%2Csz%401320_220%2Cta%40iphone___24_114.0/baiduid=F1BD74DD0C366F1BB70FB12F7BD26085/w=0_10_/t=iphone/l=1/tc?ref=www_iphone&lid=10743554539379830353&order=1&fm=alop&isAtom=1&clk_info=%7B%22tplname%22:%22wenda_abstract%22%2C%22srcid%22:%2236402%22%2C%22jumpType%22:%22%22%7D&is_baidu=0&tj=9za_1_0_10_l1&wd=&eqid=9518c5ee88c52e5110000004e21a8d&w_qd=IlPT2AEptyoA_yi5FECcJ7Cx3SVTf-UovD5ZfQ8UufErQ4kyXlBd9InhaBRqldsT8R6wH1U0LWy&bdver=2_1&tcplug=1&dict=-1&sec=32149&di=a96b7af6bb560d0a&bdenc=1&nsrc=ymSSqmJYks1v0lJAbU3gpXg93N7bymY4O/O9iVFlHXokQbDzsHDbEPRBVpRDk6AOIdP3ZjOixauIu5ms3xDognZ2gXFxFGB2vK%2BYIy2l4ciGTo2S86WYuFnYRlsoVHXxP6bN%2BrICkgtvUb/9i0EBAolU5MAnkkDKipGJEMaS/BazMriAqb4RmRCrBG68LN7tOavbPplPf4AhE5fnqH3gZRVy/Ptq4Vdot1ilgoFr1UWBm6FlyZv2hziIyn7ei4Br744hWyrLfcqKZW7Sh4EFywPGnCIUSeGOb9o9QTKrcTgNjYLMbae4/0QyCA3OuqVvI0hLKZGozLSSoqtTwgLzVtI8fM9Zz6s233Zk%2Bb0vDRzZyRRpx2DqEADmY2LeCtSaNju8TTzwkj/RRCNmo7hSNlGrC7ucCvqDozcyoBA6SR8rBEJ/NHgxpvDnmqSKoHa/6Qf4LLhdzLFN9BP3dTsNUF7BOlwJocRPUJCJ1Kx9ryti%2B2nhjrHgc3347aqG4EPT5TOiokG7VxWnQAtVbjsokg%3D%3D","originUrl":"https://activity.baidu.com/mbox/4a83aa9f/matrixShareSimple?payAskIMExp=1&fr=pay_zd_searchdqa_assign&trfsr=bdappdqa&uk=403b4069236f25705e79fba2&cate=3CIT&resourceId=302&searchId=10743554539379830353&query=excel+%E5%A6%82%E4%BD%95%E6%8A%8A%E4%B8%80%E4%B8%AA%E5%8D%95%E5%85%83%E6%A0%BC%E7%9A%84%E5%86%85%E5%AE%B9%E5%88%86%E5%BC%80","log":"{'e':'IlPT2AEptyoA_yixCFOxCGZb8c3JV3T5ABOSQSVC_yqn95u7gfTqXdNpX8KhVnKYHF7wdoTKgBUCcSWiOWAizBAxg4skcTJneCWstamLqcj3UM11f0Mo_cfjWycFrAnmn0wd9NNoRtBnR8-cffLpbvQ9beiTvAJfjhPZwCDQeLz_CVKdV67G7pm9MZwSCZPfW0uFsRfnfG9dHl7n2tTAGIW0enRJFydcag7t73JHONTYmHI53AqlIsFREo8JAj9O_q7RAPnvlh3SE6MO87J7Lk5Q5HaYgOOII8tBWhj4mKp7UavuUgn2NIi4KRxYug3OGLkeGrX0sed8P7pkh5-nFmxYB0ajQIDGVEYYW4X-irymPXhpjmT9IrOvpz2pCuK9XecT_q53OEsXq7r9mcTZsSauOrSMwLELIwhnCjvgj8x27kwqGVauh5b_9kYAcpLK_6nLEHyGQRX8SCwdju0GQhKO4_eTZmVTnWfStiimqZeEWsyZFfA4wZx6lnEF_Vft9LbrJTOYKc4tzLINpwK3lsyniDDdnprmlybLIOLVBa6n2UVVrwEwPmy6aFvueXgeCsWalCOYXVS8uJogieXkvJIOwdRsZNYeHu3vJfB8kPDxw_','c':''}","hrsf":1,"clickData":"{'clk_info':{'jumpType':''}}"}},"content":"Excel想要快速拆分单元格内容,可以进入数据界面选择分列功能就行,下面是操作步骤:点击数据。打开Excel表格,点击上方的数据。打开Excel表格,点击上方的数据。点击分列。在数据界面,点击分列功能。在数据界面,点击分列功能。点击下一步。进入分列里面,点击下一步操作即可。进入分列里面,点击下一步操作即可。
小编还为您整理了以下内容,可能对您也有帮助:
如何将Excel表格一个单元格中的文字数据进行拆分
今天给大家介绍一下如何将Excel表格一个单元格中的文字数据进行拆分的具体操作步骤。
1. 如图,我们将文档中的内容复制到表格中,就会全部挤在一个单元格里面,下面我们就将它们分开
2. 首先点击页面上方的数据菜单
3. 然后在打开的数据选项中,找到分列选项,点击
4. 在弹出的窗口中,点选上“分隔符号”选项
5.接下来,在弹出的窗口中,找到”空格“选项,在其勤勉打勾,然后”下一步“
6.如图,在返回到的上一窗口,点击右下角的完成按钮。
7. 如图,刚才挤在一起的文字、数据就全部分开显示了。