Hi, i have create a getnumberonly function which will return all the number in a cell. Example, getnumberonly(abc123xyz) = 123

however, i want to input this formula in Column C when there is a value/text in Column B. Like when someone type in ABG222 in B2, C2 will become 222 automatically.

HOw can it be done in VB?