Fill with the help of formula

Hello Everyone, 

In below screenshot, i want to fill data in NEW CODE column. 

And Blue arrow line shows for put data with decimal with the help of formula

like - 

Same for NEW DESC 

Green colour arrow to how to write :

And it should be dynamic. 

Please help

Here is a attached file