Excel: Left Function

This vidjo describes a simple application of the left() function in Excel. In this example, the left function is used to extract the area code from a phone number. All names and phone numbers in this tutorial are fake.

[jasonism]

you should have at least 1 million subs..thank you for what you do..subbed and liked!

[haribon]

How to add a period to an extracted LEFT FUNCTION? For instance: in a name ROMEO RABENA ANGELES, I extracted the LEFT FUNCTION of middle name RABENA as R so that it would appear as ROMEO R. ANGELES?