TGFC Lifestyle - Powered by Discuz! Board

标题: [电脑] 问一个excel的基本操作问题。发现我自己太白了。 [打印本页]

作者: pangeng 时间: 2013-4-2 21:47 标题: 问一个excel的基本操作问题。发现我自己太白了。

一组逗号隔开的数据
1,  -80.000m,  -11.349p,  -54.809p,  -10.968p
   2,  -70.000m,  -10.482p,  -47.141p,  -10.388p
   3,  -60.000m,  -8.8150p,  -41.948p,  -8.8432p
   4,  -50.000m,  -8.8970p,  -36.451p,  -8.9164p
   5,  -40.000m,  -7.2396p,  -33.714p,  -7.2280p
   6,  -30.000m,  -7.7195p,  -22.633p,  -7.5707p
   7,  -20.000m,  -3.9332p,  -14.482p,  -3.7275p
   8,  -10.000m,  -3.6182p,  -6.0812p,  -4.2353p
   9, 0.0000,  -1.8279p,  -1.1068p,  -1.4945p
   10, 10.000m, 1.2510p, 4.3178p, 1.2181p
   11, 20.000m, 4.4726p, 10.368p, 4.7974p
   12, 30.000m, 9.1687p, 26.884p, 9.3115p
   13, 40.000m, 13.646p, 26.751p, 13.590p
   14, 50.000m, 20.717p, 40.011p, 20.597p
   15, 60.000m, 26.559p, 69.072p, 26.406p

在拷贝粘贴到excel时，怎么让它们自动分到不同的column里？

作者: aweiwei 时间: 2013-4-2 21:54

posted by wap, platform: Chrome

分列，按符号，选择逗号。

作者: yaoppp 时间: 2013-4-2 22:19

2L正解

欢迎光临 TGFC Lifestyle (http://bbs.tgfcer.com/)