質問編集履歴
1
誤記
test
CHANGED
File without changes
|
test
CHANGED
@@ -44,7 +44,7 @@
|
|
44
44
|
|
45
45
|
A1="あいうえお12345かきくけこ67890さしすせそ"
|
46
46
|
|
47
|
-
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))))
|
47
|
+
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))))
|
48
48
|
|
49
49
|
C1=MID(A1,1,B1)
|
50
50
|
|