I'm trying to use regex to remove numbers from Column C using the formula below. it works for one cell but not for multiple. I want to apply the formula to the whole c column starting from C7

=REGEXREPLACE(C7:C, "[0-9]*\.[0-9]|[0-9]","")

Any advice?

CodePudding user response：

use:

=INDEX(REGEXREPLACE(C7:C, "[0-9]*\.[0-9]|[0-9]", ))