質問編集履歴
1
誤記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -21,7 +21,7 @@
|
|
|
21
21
|
|
|
22
22
|
```
|
|
23
23
|
A1="あいうえお１２３４５かきくけこ６７８９０さしすせそ"
|
|
24
|
-
B1=MAX((MID(ASC(A1),ROW(INDIRECT("1:"&LEN(A1))),1)={"1","2","4","5","6","7","8","9","0"})*ROW(INDIRECT("1:"&LEN(A1))))
|
|
24
|
+
B1=MAX((MID(ASC(A1),ROW(INDIRECT("1:"&LEN(A1))),1)={"1","2","3","4","5","6","7","8","9","0"})*ROW(INDIRECT("1:"&LEN(A1))))
|
|
25
25
|
C1=MID(A1,1,B1)
|
|
26
26
|
D1=MAX((MID(ASC(C1),ROW(INDIRECT("1:"&LEN(C1))),1)<>{"1","2","3","4","5","6","7","8","9","0"})*ROW(INDIRECT("1:"&LEN(C1))))
|
|
27
27
|
E1=MID(A1,D1+1,B1-D1)
|