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?
Bookmarks