I want a formula to look at a string of 10 digits and only write the last 4. How would I do that?

Hi, can i do a formula to replace a certain word in a column column a = month column b = adtext containing text including [MONTH] column c = adtext with text replacing word [MONTH] with column a Thanks!