I have data in col A in the following manner

A1 ALP_STD_Store_Fuel
A2 ALP_DEL_Store_FoodGrain
A3 DRJ_BAS_Company_Fuel
A4 STD_DTC_Office_Staff
and so on .......................

Each word is seperated with an Underscore "_"
Now I want only the last word (from Right) in each cell to be displayed on the adjucent cells.

For example
In Col B1 I want only Fuel, in B2 only FoodGrain, in B3 only Fuel and B4 only Staff.
Which command or function (without VBA) allows me to do that.

Thanks for any help you offer.