質問する

# James Evans's profile - activity

 2019-01-15 15:35:11 +0200 バッジを受け取った ● 体系学者 2014-06-26 16:27:00 +0200 バッジを受け取った ● 人気の質問 (source) 2014-06-26 16:27:00 +0200 バッジを受け取った ● 有名な質問 (source) 2014-06-26 16:27:00 +0200 バッジを受け取った ● 卓越した質問 (source) 2014-01-12 19:21:23 +0200 バッジを受け取った ● 自己学習者 (source) 2014-01-12 19:21:23 +0200 バッジを受け取った ● 教師 (source) 2014-01-12 04:43:26 +0200 質問に回答する [Calc] Partial word searches, using cell references and regular expressions. add: &"." instead of just . Code requested was: =MATCH(C2&".*", $b$2:$b$10000, 0)  2014-01-12 04:27:53 +0200 バッジを受け取った ● 編集者 (source) 2014-01-12 04:08:56 +0200 質問をする [Calc] Partial word searches, using cell references and regular expressions. So I know I can use regular expressions to do something like : =MATCH("hello.*", $b$2:$b$10000, 0)  But if i have two collums, b and c, and I want to find if the word in the cell at c is included, whole or partially, in list b. For example: B C Helpxo Help 12345-075 12345 123 123  So I want to be able to put a formula in D that gives positive matches for all of those examples. I tried: =MATCH(C2.*, $b$2:$b$10000, 0)  But, it didn't work. EDIT: Found it here's the code: =MATCH(C2&".*", $b$2:$b$10000, 0)