Loading...
In this vidjo, we show you how to use the find and replace tool to clean a column containing phone numbers in non-standard format. All names and ph...
15 views
In this vidjo, we show you how to extract the three digit area code from a phone number contained within parentheses using the mid() function in Ex...
53 views
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...
49 views
In this vidjo, I will show you how to use Excel's fill in series to create a worksheet with three columns: one column with all numbers between 1 an...
16 views