Dear all,

Is it possible to convert this formula into vb code, as the data in column B and C deals with blank cells? 

=right(left(C1, 10, 9)
I have attached a sample worksheet with example of input and desired output data.

Move column C to B.xlsm

Any help would be very much appreciated.

Thank you for your time.