FIND(find_text, within_text, [start_num])
示例:
=FIND("ha", B2)
REPLACE(old_text, start_num, num_chars, new_text)
示例:
=REPLACE(B2, FIND("(", B2), FIND(")", B2) - FIND("(", B2) + 1, "")
SUBSTITUTE(text, old_text, new_text, [instance_num])
示例:
=SUBSTITUTE(B2, "helo", "hello")
TRIM(text)
示例:
=TRIM(B2)