How to extract all characters after a specific word?

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.

Change A1 in the formula below to the actual cell reference.

Formula:

Please Login or Register  to view this content.

BSB

Try

=SUBSTITUTE(A1,"Hotel","",1)
or
=MID(A1,6,LEN(A1)-5)

Or try:

=IF(LEFT(A1,5)="Hotel",REPLACE(A1,1,5,""),A1)

Thanks BadlySpelledBuoy! Works like a charm!

Thanks @Phuocam @JohnTopley too. Your formulas work too!