remove after three & four letters , keep the first three & four letters with shift capital

hi guys !
I have some words (JAPAN,THAILAND,INDONESIA) and somtimes small letter for some the items . so any item contains (JAPAN,THAILAND,INDONESIA) should delete the letters after three or four letters then should be (JAP,THI,INDO) and if any items contain letter is small then should convert to capital letters . I put the result in second sheet , but should be in the first sheet .
thanks