![=LET(データ,A1:A2,
fn分割,LAMBDA(文,REGEXEXTRACT(文,"[\d] |[\D] ",1)),
fn漢数字,LAMBDA(ワード,
IF(ISNUMBER(--ワード),NUMBERSTRING(ワード,1),ワード)),
fn変換,LAMBDA(文,CONCAT(fn漢数字(fn分割(文)))),
MAP(データ,fn変換))](https://venexa.site/media/HCuzG4fbwAAMD3Z.jpg)
ALT =LET(データ,A1:A2, fn分割,LAMBDA(文,REGEXEXTRACT(文,"[\d] |[\D] ",1)), fn漢数字,LAMBDA(ワード, IF(ISNUMBER(--ワード),NUMBERSTRING(ワード,1),ワード)), fn変換,LAMBDA(文,CONCAT(fn漢数字(fn分割(文)))), MAP(データ,fn変換))
![=MAP(B:.B,
LAMBDA(b,SUM(MAP(REGEXEXTRACT(b&"円",". ?[兆億万円]",1),
LAMBDA(a,
REDUCE(0,MID(a,SEQUENCE(LEN(a)),1),LAMBDA(x,y,
IFERROR(COMPLEX(0,((IMREAL(x)=0) IMREAL(x))*10^FIND(y,"十百千") IMAGINARY(x)),
IFERROR(COMPLEX(MOD(FIND(y,"一二三四五六七八九〇"),10),IMAGINARY(x)),
(IMAGINARY(x) IMREAL(x))*10000^(FIND(y,"円万億兆")-1))))))))))](https://venexa.site/media/G1D2lc2aoAIADBJ.jpg)
ALT =MAP(B:.B, LAMBDA(b,SUM(MAP(REGEXEXTRACT(b&"円",". ?[兆億万円]",1), LAMBDA(a, REDUCE(0,MID(a,SEQUENCE(LEN(a)),1),LAMBDA(x,y, IFERROR(COMPLEX(0,((IMREAL(x)=0) IMREAL(x))*10^FIND(y,"十百千") IMAGINARY(x)), IFERROR(COMPLEX(MOD(FIND(y,"一二三四五六七八九〇"),10),IMAGINARY(x)), (IMAGINARY(x) IMREAL(x))*10000^(FIND(y,"円万億兆")-1))))))))))
![=LET(
_an,SEQUENCE(10,1,0),
_kn,TEXT(_an,"[DBNum1]0"),
_split,MID($B$2,SEQUENCE(11),1),
_astr,CONCAT(IFNA(INDEX(_an,MATCH(_split,_kn,0)),_split)),
_serial,_astr XLOOKUP(A3,{"翌日","翌々日","翌週","昨日","一昨日","先週"},{1,2,7,-1,-2,-7},0),
TEXT(_serial,"[DBNum1]yyyy年m月d日")
)](https://venexa.site/media/Go3sUuXa4AAv8Fz.png)
ALT =LET( _an,SEQUENCE(10,1,0), _kn,TEXT(_an,"[DBNum1]0"), _split,MID($B$2,SEQUENCE(11),1), _astr,CONCAT(IFNA(INDEX(_an,MATCH(_split,_kn,0)),_split)), _serial,_astr XLOOKUP(A3,{"翌日","翌々日","翌週","昨日","一昨日","先週"},{1,2,7,-1,-2,-7},0), TEXT(_serial,"[DBNum1]yyyy年m月d日") )
ALT =LET( _an,SEQUENCE(10,1,0), _kn,TEXT(_an,"[DBNum1]0"), _split,MID($B$2,SEQUENCE(11),1), _astr,CONCAT(IFNA(INDEX(_an,MATCH(_split,_kn,0)),_split)), _serial,_astr XLOOKUP(A3,{"翌日","翌々日","翌週","昨日","一昨日","先週"},{1,2,7,-1,-2,-7},0), TEXT(_serial,"[DBNum1]yyyy年m月d日") )
ALT =NUMBERSTRING(YEAR(B1),3)&"年"&NUMBERSTRING(MONTH(B1),3)&"月"&NUMBERSTRING(DAY(B1),3)&"日"
![257000
456000
566900
425000
350000
439000
472700
100000
145000
248000
237000
1300000
30000
628800
335000
728000
223000
102000
=TEXT(LOOKUP(B3,{3,5,10,20,30,50,100}*10000),"[DBnum1]")&"石"](https://venexa.site/media/GlH-9tvbQAA0lbZ.png)
ALT 257000 456000 566900 425000 350000 439000 472700 100000 145000 248000 237000 1300000 30000 628800 335000 728000 223000 102000 =TEXT(LOOKUP(B3,{3,5,10,20,30,50,100}*10000),"[DBnum1]")&"石"
