![Splitting/Extracting Username and Domain name in Email address using Excel [LEFT and FIND function explained]](../../wp-content/uploads/2013/05/excel-tips-and-tricks-150x150.png)
Splitting/Extracting Username and Domain name in Email address using Excel [LEFT and FIND function explained]
A classical scenario to understand the excellence of Excel. There might be situations where we would like to split the email address in two parts i.e. the username (part at the left of @ symbol) and the domain name (part at the right of @ symbol). For example [email protected] has the username hasaanfazalpk and gmail.com is the domain name. So consider […]
![Creating Currency Converter in Excel [How To]](../../wp-content/uploads/2012/09/excel-page-featured-image-150x150.png)
Creating Currency Converter in Excel [How To]
In the world we live in where almost every country has its own distinct currency and value, we almost always feel a need to convert one currency to another. These days it is easy as we can look for them over the internet and calculate how much a dollar is in terms of Pakistan Rupee. […]
Extract File Extension from file names in Excel - [Quick Tip]
What if your manager gave you a file with thousands of file names and you have to extract file extensions? If you are following our Excel tutorials on regular basis then it won’t be a problem as we have covered few of the ways that can be used to carry out this task. General knowledge […]
Extracting Integer and Decimal portion from a number in different cells - Part 1
When it comes to information then most of the time its about numbers and often numbers come with decimals i.e. numbers that are written as: 9.82 0.9856486 1021587.986244 But what if we are only interested in decimal portion (fractional part) of the number or we are interested in the integer (integral part) of the number? […]
