①dirコマンド
dir /b /s /a-d | clip
②Excel関数
=MID(SUBSTITUTE(A1,LEFT(A1,FIND(">",SUBSTITUTE(A1,"\",">",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))),1)-1),""),2,LEN(A1))
More than 3 years have passed since last update.
①dirコマンド
dir /b /s /a-d | clip
②Excel関数
=MID(SUBSTITUTE(A1,LEFT(A1,FIND(">",SUBSTITUTE(A1,"\",">",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))),1)-1),""),2,LEN(A1))
Register as a new user and use Qiita more conveniently