| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extracting text from a cell entry
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 -- morchard ------------------------------------------------------------------------ morchard's Profile: http://www.excelforum.com/member.php...o&userid=24761 View this thread: http://www.excelforum.com/showthread...hreadid=384874 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
| Text in cell as Formula | Excel Discussion (Misc queries) | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
| How do I print all the text in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
