I have column with thousands of data entires e.g.

AAL
AAR
AAR
ABJ
ABJ
ABJ
ABJ
ABJ
ABV

These are airport codes if you're really interested!

Some of the entries have an apostrophe in front of the three character code i.e. in the formula window it may actually appear as 'AAL Other entries sometimes have two or more blank spaces after them.

Is there a way I can just extract the three digit text string from these entries so that I can create a new column with just the three leter codes and no spaces or apostrohe's?

Many Thanks