{"title":"\u3010Excel\u3011\u5de6\u5074\u30920\u3067\u57cb\u3081\u3066\u56fa\u5b9a\u9577\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5 (\u5148\u982d\u306b0\u3092\u8ffd\u52a0\u3057\u3066\u6841\u3092\u5408\u308f\u305b\u308b)","description":"\u672c\u8a18\u4e8b\u3067\u306f\u3001\u30c7\u30fc\u30bf\u306e\u5de6\u5074\u30920\u3067\u57cb\u3081\u3066\u56fa\u5b9a\u9577\u306e\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u793e\u54e1\u30b3\u30fc\u30c9\u3001\u90e8\u9580\u30b3\u30fc\u30c9\u306a\u3069\u306e\u3088\u3046\u306b\u6c7a\u307e\u3063\u305f\u6841\u6570\u306e\u30b3\u30fc\u30c9\u3067\u3001\u5148\u982d\u30920\u3067\u57cb\u3081\u305f\u3044\u3068\u304d\u306b\u6d3b\u7528\u3067\u304d\u307e\u3059\u3002 REPT\u95a2\u6570\u3068LENB\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001\u30c7\u30fc\u30bf\u306e\u5de6\u5074\u30920\u3067\u57cb\u3081\u308b\u65b9\u6cd5 \u4ee5\u4e0b\u753b\u50cf\u3067\u306f\u3001A\u5217\u306e\u5143\u30c7\u30fc\u30bf\u3092\u3001B\u5217\u3067REPT\u95a2\u6570\u3001LENB\u95a2\u6570\u3092\u4f7f\u7528\u3057\u30665\u6841\u306e\u56fa\u5b9a\u9577\u30c7\u30fc\u30bf\u306b\u5909\u63db\u3057\u3066\u3044\u307e\u3059\u3002\u6841\u304c\u8db3\u308a\u306a\u3044\u5834\u5408\u306f\u5148\u982d\u30920\u3067\u57cb\u3081\u3066\u3044\u307e\u3059\u3002 REPT\u95a2\u6570\u30fbLENB\u95a2\u6570\u30670\u57cb\u3081\u3057\u3066\u6841\u6570\u3092\u5408\u308f\u305b\u308bB2\u30bb\u30eb\u306e\u6570\u5f0f\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002 =REPT(0,5-LENB(A2))&A2 \u300cA2\u300d\u3092\u5bfe\u8c61\u30c7\u30fc\u30bf\u304c\u306e\u30bb\u30eb\u3001 \u300c5\u300d\u306e\u90e8\u5206\u3092\u4efb\u610f\u306e\u6841\u6570\u306b\u5909\u66f4\u3057\u3066\u6d3b\u2026","height":"190","categories":["Excel"],"author_name":"auroralights","author_url":"https://blog.hatena.ne.jp/auroralights/","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/a/auroralights/20250327/20250327235309.png","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fauroralights.jp%2Fentry%2F2025%2F03%2F28%2F002857\" title=\"\u3010Excel\u3011\u5de6\u5074\u30920\u3067\u57cb\u3081\u3066\u56fa\u5b9a\u9577\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5 (\u5148\u982d\u306b0\u3092\u8ffd\u52a0\u3057\u3066\u6841\u3092\u5408\u308f\u305b\u308b) - \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>","url":"https://auroralights.jp/entry/2025/03/28/002857","type":"rich","provider_name":"Hatena Blog","width":"100%","blog_url":"https://auroralights.jp/","version":"1.0","provider_url":"https://hatena.blog","blog_title":"\u30aa\u30fc\u30ed\u30e9\u3055\u3093\u306e\u52c9\u5f37\u5e33","published":"2025-03-28 00:28:57"}