Excel中基于用户定义规则的文本编码(转换为数字) [英] Text encoding (converting to numeric) based on user-defined rules in Excel

问题描述

我有文本形式的数据，我需要根据我定义的规则将其编码/转换为数字形式.澄清:

I have data in text form that I need to encode/convert to numeric form according to rules I defined. To clarify:

需要输出列的公式，以便将原始文本数据与文本编号编码规则进行比较，并返回每行文本的数值.

Need formula for output column so that it compares original text data with text-number encoding rules and returns numeric value of text in each row.

推荐答案

把这个放到 C3 里往下拉:

Put this in C3 and drag down:

=INDEX(F$2:F$6,MATCH(A3,E$2:E$6,0))

这篇关于Excel中基于用户定义规则的文本编码(转换为数字)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！