## How to use Wildcards with VLOOKUP in Excel

I'm sure you want to make VLOOKUP more powerful.Well, using wildcards with VLOOKUP can do this for you.It [...]

I'm sure you want to make VLOOKUP more powerful.Well, using wildcards with VLOOKUP can do this for you.It [...]

In Excel, when we normally combine text from different cells using CONCATENATE.But sometimes while doing this we need [...]

How to Calculate Ratio in Excel A ratio is one of the common methods to compare two [...]

In Excel, there is no direct function to get quarter from a date.But you can create a formula [...]

Excel is like a Swiss army knife for calculations.From mathematical to financial, it’s for every single thing you [...]

And after that, I told him about five different methods for this but then he got confused about which method is easy. Even I have created a small UDF to make it super easy for him to remove n number of characters from the start of a string.