try to save this file as a csv suffix, and open it in excel, you will see the magic. hola [email protected], last signin: 2021-09-13 08:36:18.882352 [email protected], last signin: 2021-09-13 08:36:18.882352 [email protected], last signin: 2021-09-13 08:36:18.882352 [email protected], last signin: 2021-09-13 08:36:18.882352 or another way, you just need a notepad++
try to save this file as a csv suffix, and open it in excel, you will see the magic. hola [email protected], last signin: 2021-09-13 08:36:18.882352 [email protected], last signin: 2021-09-13 08:36:18.882352 [email protected], last signin: 2021-09-13 08:36:18.882352 [email protected], last signin: 2021-09-13 08:36:18.882352 or another way, you just need a notepad++ huashan2018 发表于 2021-09-13 15:24
谢谢所有回帖的mm,你们太棒了。 data-》text to column works。 flash那个我没有弄明白。 save it as csv file then open it in excel works, and simple!!!
吃瓜的讲你要做2步。第一步用Excel Text to Column, 选delimiter Comma 和 Other :。这样有好几个column. 去掉last signin column. 第二步是用string concatenation 把3个column的数字变成一个column: eg: =A1 & ":" & B1 & ":" C1. Drag to fill all rows. Copy the new column containing the concatenated strings. In a new cell, use paste special, select "values" so the new column values have no dependencies.
需要把它们放进excel的两个column里:email,last signin 求帮助
[email protected], last signin: 2021-09-13 08:36:18.882352 [email protected], last signin: 2021-09-13 08:36:18.882352 [email protected], last signin: 2021-09-13 08:36:18.882352 [email protected], last signin: 2021-09-13 08:36:18.882352
or another way, you just need a notepad++
正解
谢谢所有回帖的mm,你们太棒了。 data-》text to column works。 flash那个我没有弄明白。 save it as csv file then open it in excel works, and simple!!!
万能的华人
用 text to column, youtube 上有很多视频教程,可以看一下,非常实用。