Excel 2013 Tutorial - How to Extract Parts of a Text String
In this tutorial you will learn:
How to extract parts of a text.
USING THE EXCEL FUNCTIONS: RIGHT, LEFT AND MID YOU WILL BE ABLE TO:
1- EXTRACT SPECIFIC POSITIONS OF TEXT.
2- CONVERT 9-DIGITS POSTAL CODES INTO 5-DIGITS POSTAL CODES.
3- EXTRACT PHONE NUMBERS WITHOUT THE AREA CODE.
4- EXTRACT PARTS OF EMPLOYEE OR JOB CODES FOR USE SOMEWHERE ELSE.