Extracting text from a cell entry

[morchard]

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

[Ron Coderre]

If the codes are in Column A, beginning in A2:

B2: =TRIM(A2)

Copy that formula down
Select from B2:B1000 (or the last cell of the list)
Edit>Copy
Edit>Paste Special>Values

Does that help?

Ron

[morchard]

Thanks Ron, that worked perfectly!