[Affiliate]
Blog Stats
- 3,289,839 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- #Excel Add current selection to filter. What it does?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Show number in thousand (k) or in million (M) by using custom format
- Dropdown calendar in Excel
- Limitation (or bug?) with Filter by Color
- Do you know Menu Key??
- How to sort bar chart in descending order?
- Combine files in a folder with Power Query in #Excel
- The INDIRECT trick of using Structured Reference in Conditional Formatting
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
Transform boring Excel reports into Business IntelligenceĀ
Dashboard Course by MYNDA TREACY is now open Last week, I shared the news about the free Excel Dashboard Webinars by Mynda. I hope you did find a time to join the webinars. If you haven’t watched the Webinars and … Continue reading
Excel Humor #5 – Are you relying on Excel too much?
Are you an Excel Dependency? Do you use Excel even for simple maths? Ā Sometimes I do. š
Text manipulation with Excel functions
We talked about RIGHT, LEFT, MID, UPPER, LOWER, PROPER, FIND, SEARCH, REPLACE and SUBSTITUTE in the past few weeks. Ā Now it’s time to put every thing together to solve a problem. Ā This is actually the most amazing part of using … Continue reading
Case-insensitive SUBSTITUTE???…
We talked about REPLACE and SUBSTITUTE last week. Ā At the final note, I said that SUBSTITUTE is case-sensitive. Ā If we need to perform a case-insensitive SUBSTITUTE, it is indeed not an easy job unless we are talking a single letter … Continue reading
REPLACE vs. SUBSTITUTE in Excel
Another pair of functions that has very similar meaning literally. Ā Although I am not able to tell you the differences between “replace” and “substitute” in English, I can show you the differences of the REPLACE and SUBSTITUTE in Excel. … Continue reading
FIND vs. SEARCH
In many situations, we use either FIND or SEARCH together with LEFT, RIGHT, MID to achieve what we need. Ā A typical example is to extract theĀ first name and the last name from a full name where a coma acts as … Continue reading
UPPER, lower, Proper
I am wondering why these functions are not available in Word, but Excel? Don’t make me wrong. Ā I like these functions. Ā Nevertheless I am not a big fan (nor a small fan) of using Excel as word processor. Ā Whenever possible, … Continue reading
RIGHT. I LEFT. In the MID of…
Obviously this post is about the most popular text related functions in Excel. Ā Meanwhile, it is also a message from me… Yes, you are RIGH! I LEFT my ex-company and have landed on a new job which is much more … Continue reading
Custom List is so good
Did you know… you can create a list of Month and Day of Week by drag and drop? Ā You probably knew it on the first week of your Excel journey…Ā But did you know that, Excel may also give … Continue reading
Open sesame with Alt+ā
Alt+ā is absolutely one of my frequently used shortcuts when using Excel. What it does? Ā “Open sesame” under four common circumstances. š When you are at the bottom of a column Ā Ā Alt+ā displays the list of items on the column. … Continue reading
Extract 6 digits from a string and convert it into date
Got a question about how to extractĀ the date of birthday (DOB) portion from an ID number likeĀ 63102400965, where the first 6 digits represent the DOB, so that we could use the date for other calculation. Ā In this example the DOB … Continue reading
Display single letter Day of week in Excel
Is it achievable? Ā Not by formatting but formula.
Number Stored as Text…
It is something basic and commonly seen. Ā Nonetheless, Ā it is really important to understand the different behaviors betweenĀ a number, and a number stored as text, especially if you want to move forward to write effective formula. Ā This post is intended … Continue reading
Copy customized Ribbon and QAT to another PC
Customized Ribbon and QAT is very common. Ā I believe all serious Excel users will have their own customized Ribbon and QAT according to their own working habits. I rarely share my customization with others and I am not going to … Continue reading
Excel Humor #4 – Excel is the perfect tool for…
Like and/or share this post if you agree it. Ā š
Boost Excel Skill with Pivot Table
I think I must have missed the email from Mynda Treacy regarding the Xtreme PivotTables Course on her site: myOnlineTrainingHub, otherwise you should have read this post earlier. I use Pivot Table a lot and consider it a must-have skill … Continue reading
Reference to a cell without source number format
You probably knew it… when weĀ make a direct reference to a cell, i.e. input =A1 in A2, the cell A2 will then follow the number format of A1. Ā Put it in other words, if the number format of A1 is … Continue reading
Three different ways to do case-sensitive lookup
If you do VLOOKUP, you probably know that one of the limitations of VLOOKUP is case-insensitive. Ā It means case is not a consideration in the lookup process, where PETER is essentially the same as peter. Hence VLOOKUP will consider that … Continue reading
wmfexcel 