Extracting text from a cell entry

M

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extracting numbers from variable text 8
Excel If a Cell Contains a Certain Text (From Another Table) 0
Extracting an exact phrase from a Cell 4
Extracting numbers from a cell with carriage returns 4
Extracting numbers from a cell 2
Macro 2 insert formula if part of cell contains specific text 5
delete certain text from a cell 10
Extracting Text from a cell 5

Top