Excel Find & Paste Formula

[Closed]
Report
-
Hello,


I have a list of product name in cell A containing country name and I wanted to bring put that country name into an adjacent cell. Do you have any formula to do this?

sample

Cell A
Golden Apple India
Red Apple China
Black Grapes USA

Output
Cell B
India
China
USA