Hi all,

I need help on the relevant formula to extract all characters after a specific word used in a text.

Column A of my Excel Worksheet has the following information (extract):

HotelABCLtd
HotelCoindeMire
HotelTropical Hotel Ltd
HotelParadise Hotel

This is my expected output (I need to get rid of the word Hotel at the beginning of each Text):

ABC Ltd
CoindeMire
Tropical Hotel Ltd
Paradise Hotel


Assuming the first text is located at A1, what would be the formula to achieve this extraction?

Any help would be appreciated.