十六進制轉十進制:
DEC2HEX(A1)
補零函數:
=TEXT(A1,'00000') (适用于數字補零)
=REPT(0,5-LEN(A1))&A1(适用于任何場景)
csv檔案合并(bat批處理代碼):
@echo off
dir
copy *.csv all.csv
echo concat succeed...
pause
十六進制轉十進制:
DEC2HEX(A1)
補零函數:
=TEXT(A1,'00000') (适用于數字補零)
=REPT(0,5-LEN(A1))&A1(适用于任何場景)
csv檔案合并(bat批處理代碼):
@echo off
dir
copy *.csv all.csv
echo concat succeed...
pause