{"width":"100%","provider_name":"Hatena Blog","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/a/auroralights/20201231/20201231122909.png","author_url":"https://blog.hatena.ne.jp/auroralights/","blog_url":"https://auroralights.jp/","height":"190","blog_title":"\u30aa\u30fc\u30ed\u30e9\u3055\u3093\u306e\u52c9\u5f37\u5e33","description":"Left\u95a2\u6570\u30fbRight\u95a2\u6570\u30fbMid \u95a2\u6570\u306b\u3064\u3044\u3066 Left\u95a2\u6570 Right\u95a2\u6570 Mid\u95a2\u6570 Instr\u95a2\u6570\u306b\u3064\u3044\u3066 Len\u95a2\u6570\u306b\u3064\u3044\u3066 \u6587\u5b57\u5217\u3092\u64cd\u4f5c\u3059\u308b5\u3064\u306e\u95a2\u6570\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 Left\u95a2\u6570\u30fbRight\u95a2\u6570\u30fbMid \u95a2\u6570\u306b\u3064\u3044\u3066 Left\u95a2\u6570\u3001Right\u95a2\u6570\u3001Mid\u95a2\u6570\u306f\u5f15\u6570\u3067\u6307\u5b9a\u3057\u305f\u6587\u5b57\u5217\u304b\u3089\u3001\u4e00\u90e8\u306e\u6587\u5b57\u5217\u3092\u8fd4\u3059\u95a2\u6570\u3067\u3059\u3002\u5404\u95a2\u6570\u306e\u9055\u3044\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002 Left\u95a2\u6570 Left\u95a2\u6570\u306f\u3001\u5f15\u6570\u306b\u6307\u5b9a\u3057\u305f\u6587\u5b57\u5217\u6587\u5b57\u5217\u306e\u5de6\u7aef\u304b\u3089\u3001\u5f15\u6570\u3067\u6307\u5b9a\u3057\u305f\u6587\u5b57\u6570\u5206\u306e\u6587\u5b57\u5217\u3092\u8fd4\u3057\u307e\u3059\u3002 \u69cb\u6587Left(\u6587\u5b57\u5217,\u6587\u5b57\u6570) LEFT\u95a2\u6570\u306e\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9 \u30bb\u30ebA1\u3078\u306f\u3001\u5909\u6570a\u306b\u683c\u7d0d\u3055\u308c\u305f\u6587\u5b57\u5217\u306e\u5185\u3001\u5de6\u7aef\u304b\u30892\u6587\u5b57\u5206\u304c\u4ee3\u5165\u2026","version":"1.0","published":"2020-12-31 21:30:00","type":"rich","title":"\u3010Excel VBA \u30a8\u30ad\u30b9\u30d1\u30fc\u30c8 \u30d9\u30fc\u30b7\u30c3\u30af\u3011\u6587\u5b57\u5217\u7cfb\u306e\u95a2\u6570\u3000(Left\u30fbRight\u30fbMid\u30fbInstr\u30fbLen) (VBA\u5165\u958024)","provider_url":"https://hatena.blog","author_name":"auroralights","categories":["Excel VBA","Excel VBA BASIC"],"url":"https://auroralights.jp/entry/2020/12/31/213000","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fauroralights.jp%2Fentry%2F2020%2F12%2F31%2F213000\" title=\"\u3010Excel VBA \u30a8\u30ad\u30b9\u30d1\u30fc\u30c8 \u30d9\u30fc\u30b7\u30c3\u30af\u3011\u6587\u5b57\u5217\u7cfb\u306e\u95a2\u6570\u3000(Left\u30fbRight\u30fbMid\u30fbInstr\u30fbLen) (VBA\u5165\u958024) - \u30aa\u30fc\u30ed\u30e9\u3055\u3093\u306e\u52c9\u5f37\u5e33\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}