{"blog_url":"https://www.k-hitorigoto.online/","image_url":null,"type":"rich","blog_title":"\u7ba1\u7406\u4ebaK\u306e\u3072\u3068\u308a\u3054\u3068","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.k-hitorigoto.online%2Fentry%2F2017%2F03%2F05%2F202924\" title=\"\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u3067lastIndexOf\u3059\u308b(Excel) - \u7ba1\u7406\u4ebaK\u306e\u3072\u3068\u308a\u3054\u3068\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"ksk1130","published":"2017-03-05 20:29:24","width":"100%","height":"190","categories":["Excel"],"provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/ksk1130/","title":"\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u3067lastIndexOf\u3059\u308b(Excel)","description":"\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u306b\u306flastIndexOf\u306b\u4f3c\u305f\u95a2\u6570\u306a\u3044\u3093\u3067\u3059\u306d... \u3068\u3044\u3046\u308f\u3051\u3067\u3001\u306a\u3093\u3068\u304b\u9811\u5f35\u3063\u3066\u307f\u307e\u3057\u305f\u3002\u305d\u3057\u3066\u3001\u305d\u3044\u3064\u3092\u4f7f\u3063\u3066\u30d5\u30eb\u30d1\u30b9\u304b\u3089\u62e1\u5f35\u5b50\u3092\u53d6\u5f97\u3057\u3066\u307f\u307e\u3057\u305f\u3002 # \u300cA1\u300d\u30bb\u30eb\u306e\u5185\u5bb9\u304b\u3089\u3001\u62e1\u5f35\u5b50(\u6700\u5f8c\u306e\u300c.\u300d\u3088\u308a\u53f3\u5074\u306e\u6587\u5b57\u5217)\u3092\u53d6\u5f97\u3059\u308b\u5f0f\u3067\u3059 =RIGHT(A1,LEN(A1)-FIND(\"$\",SUBSTITUTE(A1,\".\",\"$\",LEN(A1)-LEN(SUBSTITUTE(A1,\".\",\"\"))))) ' \u4ee5\u4e0b\u306f\u304b\u307f\u7815\u3044\u305f\u3084\u3064\u3067\u3059 =RIGHT(A1, '\u4e00\u756a\u6700\u5f8c\u306e\u63a2\u7d22\u5bfe\u8c61\u6587\u5b57(\".\")(\"$\"\u306b\u7f6e\u63db\u3055\u308c\u305f)\u4ee5\u964d\u306e\u6587\u5b57\u5217\u3092\u6c42\u3081\u308b(4) LEN(A1)-FIND(\"$\"\u2026","url":"https://www.k-hitorigoto.online/entry/2017/03/05/202924","version":"1.0","provider_url":"https://hatena.blog"}