I am new at excel VB and seek assistant in the following problem below:

I have a column A with following values below:

```
column A
"VL50s"
"M50s"
"H50s"
"VL50s"
"H50s"

```

I would like to extract the numbers and run the following arithmetic function below into coloumn B.

```
key:
x is a number
VLx --> (x) + 1
Mx -->(x) + 2
Hx --> (x) + 3

```

the output should look like the following using the key above:

```
coloumn B
51
52
53
51
53

```

I would like to ask how would i go about doing this function in VBA. Thank you for your assistance.