{"id":83487,"date":"2024-11-09T08:24:58","date_gmt":"2024-11-08T23:24:58","guid":{"rendered":"https:\/\/www.excel-no-mori-blog.jp\/?p=83487"},"modified":"2024-10-23T20:21:00","modified_gmt":"2024-10-23T11:21:00","slug":"%ef%bd%83%ef%bd%83-3","status":"publish","type":"post","link":"https:\/\/www.excel-no-mori-blog.jp\/?p=83487","title":{"rendered":"\u3010\u30a8\u30af\u30bb\u30eb\u3011CELL\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3002\u300cfilename\u300d\u3067\u30d5\u30a1\u30a4\u30eb\u540d\u3084\u30b7\u30fc\u30c8\u540d\u3092\u53d6\u5f97"},"content":{"rendered":"\n

\u30a8\u30af\u30bb\u30eb\u306eCELL\u95a2\u6570<\/span>(\u30bb\u30eb\u95a2\u6570)\u306f\u3001\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e\u60c5\u5831\u3092\u8868\u793a\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n

\u4f8b\u3048\u3070\u3001Excel\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5148\u540d\u3084\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d\u3001\u884c\u756a\u53f7\u3001\u5217\u756a\u53f7\u3001\u8868\u793a\u5f62\u5f0f\u306a\u3069\u306e\u60c5\u5831\u3092\u62bd\u51fa<\/span>\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001CELL\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3068\u3001CELL\u95a2\u6570\u3092\u4f7f\u3063\u305f\u4e8b\u4f8b\u3092\uff15\u3064\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

<\/i>\u3053\u306e\u8a18\u4e8b\u3067\u7d39\u4ecb\u3059\u308b\u3053\u3068<\/p>

\n

\u30fbCELL\u95a2\u6570\u306e\u4f7f\u3044\u65b9<\/p>\n\n\n\n

\u30fb\u4e8b\u4f8b\uff11\uff1aCELL\u95a2\u6570\u3067\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5148<\/span>\u3092\u53d6\u5f97\u3059\u308b<\/p>\n\n\n\n

\u30fb\u4e8b\u4f8b\uff12\uff1aCELL\u95a2\u6570\u3067\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d<\/span>\u3092\u81ea\u52d5\u3067\u53d6\u5f97\u3059\u308b<\/p>\n\n\n\n

\u30fb\u4e8b\u4f8b\uff13\uff1aCELL\u95a2\u6570\u3067Excel\u30d5\u30a1\u30a4\u30eb\u540d<\/span>\u3092\u81ea\u52d5\u3067\u53d6\u5f97\u3059\u308b<\/p>\n\n\n\n

\u30fb\u4e8b\u4f8b\uff14\uff1aCELL\u95a2\u6570\u3068IF\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b<\/span><\/p>\n\n\n\n

\u30fb\u4e8b\u4f8b\uff15\uff1aCELL\u95a2\u6570\u3067\u7570\u306a\u308b\u8868\u793a\u5f62\u5f0f\u306e\u30bb\u30eb\u3092\u63a2\u3059<\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n

CELL\u95a2\u6570\u306e\u4f7f\u3044\u65b9<\/h2>\n\n\n\n

\u30a8\u30af\u30bb\u30eb\u306eCELL\u95a2\u6570<\/span>(\u8aad\u307f\u65b9\uff1a\u30bb\u30eb)\u3068\u306f\u3001Excel\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5148\u540d(\u30a2\u30c9\u30ec\u30b9\u3001\u30d1\u30b9)\u3084\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d\u3001\u884c\u756a\u53f7\u3001\u5217\u756a\u53f7\u3001\u8868\u793a\u5f62\u5f0f\u306a\u3069\u306e\u30bb\u30eb\u306e\u60c5\u5831\u3092\u53d6\u5f97\u3059\u308b\u95a2\u6570<\/span>\u3067\u3059\u3002<\/p>\n\n\n\n

\u82f1\u8a9e\u306ecell\u304cExcel\u306e\u30bb\u30eb\u306e\u3053\u3068\u306a\u306e\u3067\u3001\u6a5f\u80fd\u304c\u30a4\u30e1\u30fc\u30b8\u3057\u3084\u3059\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\u305d\u308c\u3067\u306f\u3001CELL\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u8a73\u3057\u304f\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

<\/div>\n\n\n\n

CELL\u95a2\u6570\u306e\u66f8\u5f0f\u3068\u5f15\u6570<\/h3>\n\n\n\n

CELL\u95a2\u6570\u306e\u66f8\u5f0f(\u69cb\u6587)\u3068\u5f15\u6570\u306f\u3001\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n

\uff1dCELL(\u691c\u67fb\u306e\u7a2e\u985e, \u53c2\u7167\u30bb\u30eb)<\/span><\/p>\n\n\n\n

<\/div>\n\n\n\n

\u7b2c\uff11\u5f15\u6570\u300c\u691c\u67fb\u306e\u7a2e\u985e\u300d<\/strong>\uff1a\u53d6\u5f97\u3057\u305f\u3044\u5185\u5bb9\u306e\u691c\u67fb\u30b3\u30fc\u30c9<\/span><\/strong>\u3092\u5165\u529b\u3057\u307e\u3059\u3002\u4f8b\u3048\u3070\u3001\u30bb\u30eb\u756a\u53f7\u3092\u53d6\u5f97\u3059\u308b\u3068\u304d\u306f\u300c\u201daddress\u201d\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\u691c\u67fb\u30b3\u30fc\u30c9\u306f\u3001\u4ed6\u306b\u3082\u201dfilename\u201d\u3001\u201drow\u201d\u306a\u3069\u8a08\uff11\uff12\u7a2e\u985e\u3042\u308a\u307e\u3059\u3002\uff08\u203b\u5f8c\u3067\u8a73\u3057\u304f\u7d39\u4ecb\uff09<\/p>\n\n\n\n

\u7b2c\uff12\u5f15\u6570\u300c\u53c2\u7167\u30bb\u30eb\u300d<\/strong>\uff1a\u30bb\u30eb\u306e\u60c5\u5831\u3092\u62bd\u51fa\u3057\u305f\u3044\u30bb\u30eb\u756a\u53f7\u3092\u9078\u629e\u3057\u307e\u3059\u3002(\u4f8b\uff1aA1\u3001B5)<\/p>\n\n\n\n

<\/div>\n\n\n\n

CELL\u95a2\u6570\u306e\u5f15\u6570\u300c\u691c\u67fb\u306e<\/strong>\u7a2e\u985e\u300d\u306b\u3064\u3044\u3066<\/h3>\n\n\n\n

CELL\u95a2\u6570\u306e\u7b2c\uff11\u5f15\u6570\u300c\u691c\u67fb\u306e\u7a2e\u985e\u300d\u306f\u3001\u8a08\uff11\uff12\u7a2e\u985e<\/span><\/strong>\u306e\u30b3\u30fc\u30c9(\u5b9a\u6570)\u304c\u5b58\u5728\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u3053\u306e\u691c\u67fb\u306e\u7a2e\u985e\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u6b32\u3057\u3044\u30bb\u30eb\u306e\u60c5\u5831\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\u691c\u67fb\u306e\u7a2e\u985e<\/td>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u53d6\u5f97\u3067\u304d\u308b\u60c5\u5831(\u623b\u308a\u5024)<\/strong><\/td><\/tr>
“address”<\/td>\u30bb\u30eb\u756a\u53f7(\u7d76\u5bfe\u53c2\u7167\u3067\u8868\u793a)<\/td><\/tr>
“col”<\/td>\u30bb\u30eb\u306e\u5217\u756a\u53f7<\/td><\/tr>
“row”<\/td>\u30bb\u30eb\u306e\u884c\u756a\u53f7<\/td><\/tr>
“color”<\/td>\u8272\u304c\u4ed8\u3044\u3066\u3044\u308b\u30bb\u30eb\u306f\u201d1\u201d\u3001\u305d\u308c\u4ee5\u5916\u306f\u201d0\u201d<\/td><\/tr>
“contents”<\/td>\u30bb\u30eb\u306e\u5024\u3092\u8868\u793a\u3002\u6570\u5f0f\u306e\u5834\u5408\u306f\u7d50\u679c\u304c\u8868\u793a\u3002<\/td><\/tr>
“filename”<\/td>\u30d5\u30a1\u30a4\u30eb\u306e\u30d1\u30b9\u540d(\u4fdd\u5b58\u5148\u3001\u30a2\u30c9\u30ec\u30b9)<\/td><\/tr>
“format”<\/td>\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\u3092\u8868\u3059\u30b3\u30fc\u30c9\u3000\u203b\u5225\u9014\u7d39\u4ecb<\/td><\/tr>
“protect”<\/td>\u30ed\u30c3\u30af\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\u306f\u201d1\u201d\u3001\u3055\u308c\u3066\u3044\u306a\u3044\u30bb\u30eb\u306f\u201d0\u201d<\/td><\/tr>
“type”<\/td>\u30bb\u30eb\u306e\u30c7\u30fc\u30bf\u5185\u5bb9\u3002\u7a7a\u767d\u30bb\u30eb\u306f\u201d\uff42\u201d\u3001\u6587\u5b57\u5217\u306f\u201d\uff29\u201d\u3001\u6570\u5024\u306a\u3069\u305d\u308c\u4ee5\u5916\u306f\u201d\uff56\u201d<\/td><\/tr>
“prefix”<\/td>\u30bb\u30eb\u306e\u6587\u5b57\u914d\u7f6e\u3092\u53d6\u5f97\u3002\u5de6\u63c3\u3048\u306f\u300c’\u300d\u3001\u4e2d\u592e\u63c3\u3048\u306f\u300c^\u300d\u3001\u53f3\u63c3\u3048\u306f\u300c”\u300d\u3001
\u4e21\u7aef\u63c3\u3048\u306f\u300c\\\u300d<\/td><\/tr>
“width”<\/td>\u30bb\u30eb\u306e\u5217\u5e45\u3002\u65e2\u5b9a\u306e\u30d5\u30a9\u30f3\u30c8\u30b5\u30a4\u30ba\u306e\u4f55\u6587\u5b57\u5206\u306e\u5217\u5e45\u304b\u6570\u5b57\u3067\u8868\u793a<\/td><\/tr>
“parentheses”<\/td>\u6570\u5024\u3092()\u3067\u56f2\u3080\u66f8\u5f0f\u306e\u30bb\u30eb\u306f\u201d1\u201d\u3001\u305d\u308c\u4ee5\u5916\u306f\u201d0\u201d<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

\u4f8b\u3048\u3070\u3001\u691c\u67fb\u306e\u7a2e\u985e\u300caddress\u300d\u3092\u4f7f\u3063\u3066\u4e0b\u306eCELL\u95a2\u6570\u3092\u633f\u5165\u3059\u308b\u3068\u3001B3\u30bb\u30eb\u306e\u30bb\u30eb\u756a\u53f7\u300c$B$3\u300d\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

=CELL(“address<\/span>“,B3)<\/span><\/p>\n\n\n

\n
\"CELL\u95a2\u6570\u306e\u4f7f\u3044\u65b9(\u5f15\u6570\uff1aaddress)\"<\/a>
CELL\u95a2\u6570\u306e\u4f7f\u3044\u65b9(\u5f15\u6570\uff1aaddress)<\/strong><\/figcaption><\/figure><\/div>\n\n\n
<\/div>\n\n\n\n

\u4e0a\u306e\u8868\u306eB3\u30bb\u30eb\u306b\u5bfe\u3057\u3066\u3001CELL\u95a2\u6570\u306e\u6b8b\u308a\u306e\u300c\u691c\u67fb\u306e\u7a2e\u985e\u300d\u3092\u4f7f\u3063\u305f\u7d50\u679c\u306f\u3001\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002\u3053\u306e\u4e2d\u3067\u3082\u3001\u300c\u201dfilename\u201d\u300d\u306f\u826f\u304f\u5229\u7528\u3055\u308c\u307e\u3059\u3002(\u4e8b\u4f8b\u306f\u5f8c\u3067\u7d39\u4ecb)<\/p>\n\n\n\n

\u691c\u67fb\u306e\u7a2e\u985e<\/td>\u3000\u3000CELL\u95a2\u6570\u306e\u66f8\u5f0f<\/td>\u623b\u308a\u5024<\/td><\/tr>
“address”<\/td>=CELL(“address”,B3)<\/td>$B$3<\/td><\/tr>
“col”<\/td>=CELL(“col”,B3)<\/td>2<\/td><\/tr>
“row”<\/td>=CELL(“row”,B3)<\/td>3<\/td><\/tr>
“color”<\/td>=CELL(“color”,B3)<\/td>0<\/td><\/tr>
“contents”<\/td>=CELL(“contents”,B3)<\/td>\u5175\u5eab\u770c\u795e\u6238\u5e02<\/td><\/tr>
“filename”<\/td>=CELL(“filename”,B3)<\/td>https:\/\/d.doc\u30fb\u30fb\u30fb<\/td><\/tr>
“format”<\/td>=CELL(“format”,B3)<\/td>G<\/td><\/tr>
“protect”<\/td>=CELL(“protect”,B3)<\/td>1<\/td><\/tr>
“type”<\/td>=CELL(“type”,B3)<\/td>1<\/td><\/tr>
“prefix”<\/td>=CELL(“prefix”,B3)<\/td>^<\/td><\/tr>
“width”<\/td>=CELL(“width”,B3)<\/td>16<\/td><\/tr>
“parentheses”<\/td>=CELL(“parentheses”,B3)<\/td>0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

CELL\u95a2\u6570\u306e\u691c\u67fb\u306e\u7a2e\u985e\u300cformat\u300d\u306b\u3064\u3044\u3066<\/h3>\n\n\n\n

CELL\u95a2\u6570\u306e\u691c\u67fb\u306e\u7a2e\u985e\u300cformat\u300d\u306f\u3001\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\u3092\u3001CELL\u95a2\u6570\u5c02\u7528\u306e\u8868\u793a\u5f62\u5f0f\u30b3\u30fc\u30c9\u3067\u8fd4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u8868\u793a\u5f62\u5f0f<\/td>\u623b\u308a\u5024<\/td><\/tr>
\u5168\u822c<\/td>G<\/td><\/tr>
0<\/td>F0<\/td><\/tr>
#,##0<\/td>,0<\/td><\/tr>
0<\/td>F2<\/td><\/tr>
#,##0.00<\/td>,2<\/td><\/tr>
$#,##0_);($#,##0)<\/td>C0<\/td><\/tr>
$#,##0_);[\u8d64]($#,##0)<\/td>C0-<\/td><\/tr>
$#,##0.00_);($#,##0.00)<\/td>C2<\/td><\/tr>
$#,##0.00_);[\u8d64]($#,##0.00)<\/td>C2-<\/td><\/tr>
0%<\/td>P0<\/td><\/tr>
0.00%<\/td>P2<\/td><\/tr>
0.00E+00<\/td>S2<\/td><\/tr>
# ?\/? \u307e\u305f\u306f # ??\/??<\/td>G<\/td><\/tr>
m\/d\/yy \u307e\u305f\u306f m\/d\/yy h:mm \u307e\u305f\u306f mm\/dd\/yy<\/td>D4<\/td><\/tr>
d-mmm-yy \u307e\u305f\u306f dd-mmm-yy<\/td>D1<\/td><\/tr>
d-mmm \u307e\u305f\u306f dd-mmm<\/td>D2<\/td><\/tr>
mmm-yy<\/td>D3<\/td><\/tr>
mm\/dd<\/td>D5<\/td><\/tr>
h:mm AM\/PM<\/td>D7<\/td><\/tr>
h:mm:ss AM\/PM<\/td>D6<\/td><\/tr>
h:mm<\/td>D9<\/td><\/tr>
h:mm:ss<\/td>D8<\/td><\/tr><\/tbody><\/table>
\u3000\u53c2\u7167\u5148\uff1aMicrosoft\u3000CELL\u95a2\u6570<\/a><\/strong><\/figcaption><\/figure>\n\n\n\n
<\/div>\n\n\n\n

\u4e8b\u4f8b\uff11\uff0eCELL\u95a2\u6570\u3067\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5148(\u30d1\u30b9\u540d)\u3092\u8868\u793a\u3055\u305b\u308b<\/h2>\n\n\n\n

CELL\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306f\u30a4\u30e1\u30fc\u30b8\u3067\u304d\u305f\u3051\u3069\u3001\u3069\u3093\u306a\u6642\u306b\u5229\u7528\u3057\u305f\u3089\u4fbf\u5229\u304b\u5206\u304b\u3089\u306a\u3044\u4eba\u306f\u591a\u3044\u306f\u305a\u3002<\/p>\n\n\n\n

\u3053\u3053\u304b\u3089\u306f\u3001CELL\u95a2\u6570\u3092\u4f7f\u3063\u305f\u4e8b\u4f8b\u3092\uff15\u3064\u7d39\u4ecb\u3057\u3066\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

<\/div>\n\n\n\n

\u307e\u305a\u3001\uff11\u3064\u76ee\u306f\u3001CELL\u95a2\u6570\u3067\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5148<\/span>\u60c5\u5831<\/span>\u3092\u8868\u793a<\/span>\u3055\u305b\u308b\u65b9\u6cd5\u3067\u3059\u3002<\/p>\n\n\n\n

Excel\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5834\u6240\u3092\u30bb\u30eb\u306b\u8868\u793a\u3055\u305b\u3066\u304a\u304f\u3068\u3001\u7528\u7d19\u306b\u5370\u5237\u3057\u305f\u969b\u3001\u3069\u306e\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u5370\u5237\u3057\u305f\u3082\u306e\u304b\u5206\u304b\u308a\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\u4f8b\u3048\u3070\u3001\u691c\u67fb\u306e\u7a2e\u985e\u300cfilename\u300d\u3092\u4f7f\u3063\u3066\u3001\u4ee5\u4e0b\u306eCELL\u95a2\u6570\u3092\u633f\u5165\u3057\u307e\u3059\u3002\u305d\u3046\u3059\u308b\u3068\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u5834\u6240\u3092\u793a\u3059\u300c\u30d1\u30b9\u540d<\/strong>\u300d\u3068\u300c\u30d5\u30a1\u30a4\u30eb\u540d<\/strong>\u300d\u3068\u300c\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d<\/strong>\u300d\u304c\u30bb\u30eb\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

=CELL(“filename<\/span>“,B4)<\/span><\/p>\n\n\n

\n
\"CELL\u95a2\u6570\u3092\u691c\u67fb\u306e\u7a2e\u985e\u300cfilename\u300d\u3067\u4f7f\u3046\u65b9\u6cd5\"<\/a>
CELL\u95a2\u6570\u3092\u691c\u67fb\u306e\u7a2e\u985e\u300cfilename\u300d\u3067\u4f7f\u3046\u65b9\u6cd5<\/strong><\/figcaption><\/figure><\/div>\n\n\n
<\/div>\n\n\n\n

\u4e0a\u306e\u6570\u5f0f\u3067\u306f\u3001CELL\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u306b\u300cB4\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u304c\u3001filename\u3092\u4f7f\u3046\u5834\u5408\u3001\u300cA1\u300d\u3067\u3082\u300cD5\u300d\u3067\u3082\u3069\u306e\u30bb\u30eb\u756a\u53f7\u3067\u3082\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

\u307e\u305f\u3001Outlook(\u30a2\u30a6\u30c8\u30eb\u30c3\u30af)\u306a\u3069\u3067\u30e1\u30fc\u30eb\u3092\u9001\u4ed8\u3059\u308b\u969b\u306b\u3001CELL\u95a2\u6570\u3067\u53d6\u5f97\u3057\u305fURL\u3092\u8cbc\u308a\u4ed8\u3051<\/span>\u3059\u308b\u3068\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5148\u3092\u77e5\u3089\u305b\u308b\u969b\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n

\n
\"CELL\u95a2\u6570\u306e\u4fdd\u5b58\u5148(\u30d1\u30b9\u540d\u306a\u3069)\u3092Outlook\u306b\u8cbc\u308a\u4ed8\u3051\"<\/a>
CELL\u95a2\u6570\u306e\u4fdd\u5b58\u5148(\u30d1\u30b9\u540d\u306a\u3069)\u3092Outlook\u306b\u8cbc\u308a\u4ed8\u3051<\/strong><\/figcaption><\/figure><\/div>\n\n\n
<\/div>\n\n\n\n

\u4e8b\u4f8b\uff12\uff0eCELL\u95a2\u6570\u3067\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d\u3092\u8868\u793a\u3055\u305b\u308b\u65b9\u6cd5<\/h2>\n\n\n\n

\u4e0b\u306e\u56f3\u306eB1\u30bb\u30eb\u306e\u3088\u3046\u306b\u3001CELL\u95a2\u6570\u306e\u691c\u67fb\u306e\u7a2e\u985e\u300cfilename\u300d\u3092\u4f7f\u3063\u3066\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d\u3092\u30bb\u30eb\u306b\u8868\u793a<\/span>\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n

\n
\"CELL\u95a2\u6570\u3067\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d\u3092\u8868\u793a\"<\/a>
CELL\u95a2\u6570\u3067\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d\u3092\u8868\u793a<\/strong><\/figcaption><\/figure><\/div>\n\n\n
<\/div>\n\n\n\n

\u30b7\u30fc\u30c8\u540d\u3092\u30bb\u30eb\u306b\u8868\u793a\u3055\u305b\u308b\u306b\u306f\u3001CELL\u95a2\u6570\u4ee5\u5916\u306b\u3082\u3001\u300eMID\u95a2\u6570<\/strong>\u300f\u300eFIND\u95a2\u6570<\/strong>\u300f\u306e\uff12\u3064\u306e\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u5229\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\u4ee5\u4e0b\u306e\uff13\u3064\u306e\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u6570\u5f0f\u3092\u3069\u306e\u30bb\u30eb\u3067\u3082\u3044\u3044\u306e\u3067\u8cbc\u308a\u4ed8\u3051<\/span><\/span><\/strong>\u3059\u308b\u3068\u3001\u4e0a\u306e\u56f3\u306e\u3088\u3046\u306b\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

=MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,31)<\/strong><\/p>\n\n\n\n

<\/div>\n\n\n\n

\u307e\u305f\u3001&\u6f14\u7b97\u5b50\u3092\u7528\u3044\u308b\u3053\u3068\u3067\u3001\u4e0b\u306e\u56f3\u306e\u3088\u3046\u306b\u3001\u30b7\u30fc\u30c8\u540d\u306e\u524d\u5f8c\u306b\u5225\u306e\u6587\u5b57(\u4f8b\uff1a\u58f2\u4e0a\u7ba1\u7406\u8868)\u3092\u8ffd\u52a0<\/span>\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n

\n
\"CELL\u95a2\u6570\u3068&\u6f14\u7b97\u5b50\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u30b7\u30fc\u30c8\u540d\u3068\u6587\u5b57\u3092\u8868\u793a\"<\/a>
CELL\u95a2\u6570\u3068&\u6f14\u7b97\u5b50\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u30b7\u30fc\u30c8\u540d\u3068\u6587\u5b57\u3092\u8868\u793a<\/strong><\/figcaption><\/figure><\/div>\n\n\n
<\/div>\n\n\n\n

\u4ee5\u4e0b\u306e\u8a18\u4e8b\u3067\u3001MID\u95a2\u6570\u3084FIND\u95a2\u6570\u306e\u5f79\u5272\u306a\u3069\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d\u306e\u8868\u793a\u65b9\u6cd5\u3068\u305d\u306e\u5fdc\u7528\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u7d39\u4ecb\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

\n
\"\"<\/dt>

\u3010\u30a8\u30af\u30bb\u30eb\u3011\u30b7\u30fc\u30c8\u540d\u3092\u95a2\u6570\u3067\u8868\u793a\u3059\u308b\u65b9\u6cd5\u3002\u8868\u306e\u984c\u540d\u3092\u30b7\u30fc\u30c8\u540d\u304b\u3089\u81ea\u52d5\u3067\u53d6\u5f97\uff01<\/p>

Microsoft Excel(\u30a8\u30af\u30bb\u30eb\uff09\u3067\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d\u3092\u8868\u306e\u30bf\u30a4\u30c8\u30eb\u306b\u3059\u308b\u4eba\u306f\u591a\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002 \u4f8b\u3048\u3070\u3001\u4e0b\u306e\u56f3\u306e … <\/p><\/div><\/dd><\/dl><\/div><\/a><\/div>\n<\/div><\/figure>\n\n\n\n

<\/div>\n\n\n\n

\u4e8b\u4f8b\uff13\uff0eCELL\u95a2\u6570\u3067Excel\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u8868\u793a\u3055\u305b\u308b\u65b9\u6cd5<\/h2>\n\n\n\n

\u4e8b\u4f8b\uff12\u306e\u30c6\u30af\u30cb\u30c3\u30af\u3092\u5fdc\u7528\u3057\u3066\u3001CELL\u95a2\u6570\u306e\u691c\u67fb\u306e\u7a2e\u985e\u300cfilename\u300d\u3092\u4f7f\u3063\u3066\u3001Excel\u30d6\u30c3\u30af\u540d\u3092\u30bb\u30eb\u306b\u8868\u793a<\/span>\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\u4e0b\u306e\u300eMID\u95a2\u6570<\/strong>\u300f\u300eFIND\u95a2\u6570<\/strong>\u300f\u300eCELL\u95a2\u6570<\/strong>\u300f\u3092\u7d44\u307f\u308f\u305b\u305f\u6570\u5f0f\u3092\u3001\u3069\u306e\u30bb\u30eb\u3067\u3082\u3044\u3044\u306e\u3067\u3001\u8cbc\u308a\u4ed8\u3051\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

=MID(CELL(“filename”,A1),FIND(“[“,CELL(“filename”,A1))+1,FIND(“]”,CELL(“filename”,A1))-FIND(“[“,CELL(“filename”,A1))-1)<\/span><\/p>\n\n\n\n

<\/div>\n\n\n\n

\u305d\u3046\u3059\u308b\u3068\u3001\u4e0b\u306e\u56f3\u306e\u3088\u3046\u306b\u3001\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u62e1\u5f35\u5b50\u4ed8\u304d\u3067\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n

\n
\"CELL\u95a2\u6570\u3092\u4f7f\u3063\u3066\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u30bb\u30eb\u306b\u8868\u793a\"<\/a>
CELL\u95a2\u6570\u3092\u4f7f\u3063\u3066\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u30bb\u30eb\u306b\u8868\u793a<\/strong><\/figcaption><\/figure><\/div>\n\n\n
<\/div>\n\n\n\n

\u3053\u306e\u6570\u5f0f\u306e\u4ed5\u7d44\u307f\u3092\u30ab\u30c6\u30b4\u30ea\u306b\u5206\u3051\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

\u305d\u308c\u305e\u308c\u306e\u95a2\u6570\u306e\u5f79\u5272\u306f\u3001\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n

CELL\u95a2\u6570\u3067\u53d6\u5f97\u3057\u305f\u4fdd\u5b58\u5148\u60c5\u5831\u306bFIND\u95a2\u6570\u3092\u4f7f\u3063\u3066\u300c[\u300d\u3068\u300c]\u300d\u306e\u4f4d\u7f6e\u3092\u8abf\u3079\u3066\u3001MID\u95a2\u6570\u3067\u30d5\u30a1\u30a4\u30eb\u540d\u3060\u3051\u3092\u53d6\u5f97\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

<\/i>\u6570\u5f0f\u306e\u4ed5\u7d44\u307f<\/p>

\n

MID\u95a2\u6570<\/strong>\u3000\u21d2\u6307\u5b9a\u3057\u305f\u6587\u5b57\u4f4d\u7f6e\u304b\u3089\u6307\u5b9a\u3057\u305f\u6587\u5b57\u6570\u5206\u3092\u53d6\u5f97<\/p>\n\n\n\n

CELL\u95a2\u6570<\/strong>\u3000\u21d2\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5148(\u30d1\u30b9\u540d\u3001\u30d5\u30a1\u30a4\u30eb\u540d\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u540d)\u3092\u53d6\u5f97<\/p>\n\n\n\n

FIND\u95a2\u6570&CELL\u95a2\u6570(\uff11\u3064\u76ee\u3001\uff13\u3064\u76ee)\u3000<\/strong>\u21d2CELL\u95a2\u6570\u3067\u53d6\u5f97\u3057\u305f\u4fdd\u5b58\u5148\u60c5\u5831\u306e\u300c[\u300d\u306e\u4f4d\u7f6e\u3092\u8abf\u3079\u308b<\/span><\/p>\n\n\n\n

FIND\u95a2\u6570&CELL\u95a2\u6570(\uff12\u3064\u76ee)\u3000<\/strong>\u21d2CELL\u95a2\u6570\u3067\u53d6\u5f97\u3057\u305f\u4fdd\u5b58\u5148\u60c5\u5831\u306e\u300c]\u300d\u306e\u4f4d\u7f6e\u3092\u8abf\u3079\u308b<\/span><\/p>\n<\/div><\/div>\n\n\n\n

<\/div>\n\n\n\n

\u6587\u5b57\u3092\u62bd\u51fa\u3059\u308bMID\u95a2\u6570\u3001\u6587\u5b57\u4f4d\u7f6e\u3092\u8abf\u3079\u308bFIND\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u8a73\u3057\u304f\u77e5\u308a\u305f\u3044\u65b9\u306f\u3001\u4ee5\u4e0b\u306e\u8a18\u4e8b\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

\n
\"\"<\/dt>

\u3010\u30a8\u30af\u30bb\u30eb\u3011\u6587\u5b57\u5217\u3092\u62bd\u51fa\u3059\u308bMID\u95a2\u6570\u3001LEFT\u95a2\u6570\u3001RIGHT\u95a2\u6570\u306e\u4f7f\u3044\u65b9<\/p>

MID\u95a2\u6570\u5185\u306bFIND\u95a2\u6570\u3092\u633f\u5165<\/p><\/div><\/dd><\/dl><\/div><\/a><\/div>\n<\/div><\/figure>\n\n\n\n

<\/div>\n\n\n\n

\u4e8b\u4f8b\uff14\uff0eCELL\u95a2\u6570\u3068IF\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u65b9\u6cd5<\/h2>\n\n\n\n

CELL\u95a2\u6570\u3068IF\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u5229\u7528<\/span><\/strong>\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

<\/div>\n\n\n\n

\u4e8b\u4f8b\u3092\uff11\u3064\u7d39\u4ecb\u3057\u307e\u3059\u3002\u4e0b\u306e\u8868\u306eE\u5217\u306b\u306f\u3001\u300cC\u5217\u306e\u5024\u00f7D\u5217\u306e\u5024\u300d\u306e\u6570\u5f0f\u304c\u633f\u5165\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\u3057\u304b\u3057\u3001D6\u30bb\u30eb\u3068D7\u30bb\u30eb\u306b\u6587\u5b57\u304c\u5165\u529b<\/span>\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001E6\u30bb\u30eb\u3068E7\u30bb\u30eb\u306e\u6570\u5f0f\u306e\u7d50\u679c\u306f\u30a8\u30e9\u30fc\u5024\u300cVALUE!\u300d<\/span>\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n

\n
\"\u6570\u5f0f\u306e\u7d50\u679c\u3067\u30a8\u30e9\u30fc\u5024\u304c\u767a\u751f\"<\/a>
\u6570\u5f0f\u306e\u7d50\u679c\u3067\u30a8\u30e9\u30fc\u5024\u304c\u767a\u751f<\/strong><\/figcaption><\/figure><\/div>\n\n\n
<\/div>\n\n\n\n

\u3053\u3093\u306a\u6642\u3001CELL\u95a2\u6570\u306e\u691c\u67fb\u306e\u7a2e\u985e\u306e\u300ctype\u300d<\/span>\u3092\u5229\u7528\u3057\u307e\u3059\u3002\u300ctype\u300d\u306f\u3001\u5bfe\u8c61\u306e\u30bb\u30eb\u304c\u7a7a\u767d\u30bb\u30eb\u306e\u5834\u5408\u306f\u201d\uff42\u201d\u3001\u6587\u5b57\u5217\u306f\u201d\uff29\u201d\u3001\u6570\u5024\u306f\u201d\uff56\u201d\u304c\u53d6\u5f97\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

IF\u95a2\u6570\u306e\u4e2d\u306b\u4ee5\u4e0b\u306eCELL\u95a2\u6570\u3092\u633f\u5165\u3059\u308b\u3053\u3068\u3067\u3001D\u5217\u304c\u6570\u5024\u306e\u5834\u5408\u306f\u300cC\u5217\u306e\u5024\u00f7D\u5217\u306e\u5024\u300d\u3092\u8a08\u7b97\u3057\u3001\u305d\u308c\u4ee5\u5916\u306e\u5834\u5408\u306f\u3001\u300c-\u300d\u3092\u8868\u793a\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n

=IF(CELL(“type”,D3)=”v”<\/span>,C3\/D3,”<\/span>–<\/span>“)<\/span><\/p>\n\n\n

\n
\"CELL\u95a2\u6570\u3068IF\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u65b9\u6cd5\"<\/a>
CELL\u95a2\u6570\u3068IF\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u65b9\u6cd5<\/strong><\/figcaption><\/figure><\/div>\n\n\n
<\/div>\n\n\n\n

\u4e8b\u4f8b\uff15\uff0eCELL\u95a2\u6570\u3067\u8868\u793a\u5f62\u5f0f\u304c\u7570\u306a\u308b\u30bb\u30eb\u3092\u63a2\u3059\u65b9\u6cd5<\/h2>\n\n\n\n

CELL\u95a2\u6570\u306e\u691c\u67fb\u306e\u7a2e\u985e\u306e\u300cformat\u300d\u3092\u5229\u7528\u3057\u3066\u3001\u8868\u793a\u5f62\u5f0f\u304c\u7570\u306a\u308b\u30bb\u30eb\u3092\u898b\u3064\u3051\u308b<\/span>\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

<\/div>\n\n\n\n

\u4f8b\u3048\u3070\u3001\u4e0b\u306e\u8868\u306e\u5404\u30bb\u30eb\u306b\u300c-1\u300d\u306e\u6570\u5024\u3092\u5165\u529b\u3059\u308b\u3068\u3001\u30d5\u30a9\u30f3\u30c8\u304c\u8d64\u5b57\u306b\u306a\u308b\u30bb\u30eb\u3068\u3001\u9ed2\u5b57\u306e\u30bb\u30eb\u306b\u5206\u304b\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

\u3053\u306e\u73fe\u8c61\u306f\u3001\u8868\u793a\u5f62\u5f0f\u304c\u7279\u6b8a\u306a\u30bb\u30eb\u304c\u8868\u5185\u306b\u6df7\u3056\u3063\u3066\u3044\u308b\u3053\u3068\u304c\u539f\u56e0\u3067\u3059\u3002<\/p>\n\n\n

\n
\"\u8868\u793a\u5f62\u5f0f\u304c\u7570\u306a\u308b\u30bb\u30eb\u304c\u6df7\u5728\"<\/a>
\u8868\u793a\u5f62\u5f0f\u304c\u7570\u306a\u308b\u30bb\u30eb\u304c\u6df7\u5728<\/strong><\/figcaption><\/figure><\/div>\n\n\n
<\/div>\n\n\n\n

\u3053\u3093\u306a\u6642\u3001\u8868\u793a\u5f62\u5f0f\u304c\u7570\u306a\u308b\u30bb\u30eb\u3092\u8abf\u3079\u308b\u305f\u3081\u306b\u3001\u8868\u306e\u96a3\u306e\u7a7a\u3044\u3066\u3044\u308b\u30bb\u30eb\u306bCELL\u95a2\u6570\u3092\u691c\u67fb\u306e\u7a2e\u985e\u300cformatd\u300d\u3067\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

=CELL(“format<\/span>“,B2)<\/span><\/p>\n\n\n

\n
\"CELL\u95a2\u6570\u3067\u8868\u793a\u5f62\u5f0f\u3092\u8abf\u3079\u308b\u65b9\u6cd5\"<\/a>
CELL\u95a2\u6570\u3067\u8868\u793a\u5f62\u5f0f\u3092\u8abf\u3079\u308b\u65b9\u6cd5<\/strong><\/figcaption><\/figure><\/div>\n\n\n
<\/div>\n\n\n\n

\u4e0a\u8a18\u3067\u8aac\u660e\u3057\u305f\u3088\u3046\u306b\u3001\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\u304c\u901a\u8ca8\u3084\u3001\u7279\u6b8a\u306a\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u300cG\u300d\u4ee5\u5916\u306e\u30b3\u30fc\u30c9<\/span>\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

\u4e0a\u306e\u4f8b\u3067\u306f\u3001\u300c,0-\u300d\u3068\u3044\u3046\u30b3\u30fc\u30c9\u304c\uff14\u3064\u306e\u30bb\u30eb\u3067\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001\u8868\u793a\u5f62\u5f0f\u304c\u7570\u306a\u3063\u3066\u3044\u308b\u30bb\u30eb\u3092\u898b\u3064\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\u5b9f\u969b\u306b\u3001\u53f3\u30af\u30ea\u30c3\u30af\u30e1\u30cb\u30e5\u30fc\u306e\u300c\u30bb\u30eb\u306e\u66f8\u5f0f\u8a2d\u5b9a\u300d\u753b\u9762\u3092\u898b\u308b\u3068\u3001\u4e0b\u306e\u56f3\u306e\u3088\u3046\u306b\u3001\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\u304c\u300c\u901a\u8ca8\u300d\u306b\u306a\u3063\u3066\u3044\u3066\u3001\u30de\u30a4\u30ca\u30b9\u306e\u6570\u5024\u304c\u8d64\u6587\u5b57\u306b\u306a\u308b\u8a2d\u5b9a\u304c\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u5206\u304b\u308a\u307e\u3059\u3002<\/p>\n\n\n

\n
\"CELL\u95a2\u6570\u3067\u8abf\u3079\u305f\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\u3092\u78ba\u8a8d\"<\/a>
CELL\u95a2\u6570\u3067\u8abf\u3079\u305f\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\u3092\u78ba\u8a8d<\/strong><\/figcaption><\/figure><\/div>\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

\u30a8\u30af\u30bb\u30eb\u306eCELL\u95a2\u6570(\u30bb\u30eb\u95a2\u6570)\u306f\u3001\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e\u60c5\u5831\u3092\u8868\u793a\u3059\u308b\u95a2\u6570\u3067\u3059\u3002 \u4f8b\u3048\u3070\u3001Excel\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5148\u540d\u3084\u3001\u30ef …<\/p>\n","protected":false},"author":1,"featured_media":83716,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,24],"tags":[],"class_list":["post-83487","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-24"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t