在Google电子表格中将单元格中的两个单词提取到另一个单元格中 [英] Extract two words from a cell in to another cell in google spreadsheet
问题描述
我是Google电子表格&想要复制范围c10中提到的类名到b3。我试图使用下面的公式，我知道这是错误的：
= query（C3：C52，copy class name where C包含单元格c10中的'class'）
C10单元格包含以下数据：
< body bgcolor =beigeclass =body> < div class =big_wrapper>
我希望以下两个单词出现在单元格b3中：
body big_wrapper
请更正上述公式。
为了更加清晰，请访问以下链接的sheet1：
https://docs.google.com/spreadsheets/d/1HfgOqprc-P34vOI-nGAionllrGAOsMovuLB5ozboWBY/edit#gid= 0
可能有更简单的方法，但试试（B3）：
= join（，regexextract（C10，class =& char（34）&（。+？）& char 34）&>。+ class =& char（34）&（。+？）& char（34）&>））
I am new to google spreadsheets & want to copy class names mentioned in range c10 in to b3. I am trying to use following formula which I know is wrong:
=query(C3:C52, "copy class name where C contains 'class' in cell c10 ")
C10 cell contains following data:
<body bgcolor="beige" class="body"> <div class="big_wrapper">
I want following two words to appear in cell b3:
body big_wrapper
Please correct above formula.
For more clarity visit sheet1 of following link:
https://docs.google.com/spreadsheets/d/1HfgOqprc-P34vOI-nGAionllrGAOsMOVuLB5ozboWBY/edit#gid=0
There may be easier ways, but try (in B3):
=join(" ", regexextract(C10, "class="&char(34)&"(.+?)"&char(34)&">.+class="&char(34)&"(.+?)"&char(34)&">"))
这篇关于在Google电子表格中将单元格中的两个单词提取到另一个单元格中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
