[Affiliate]
Blog Stats
- 3,296,057 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Sequential number for visible rows only
- About
- Advanced vlookup - wildcard characters "?" and "*"
- =SUM('???'!C3) Is it a valid formula?? No. It is magical indeed!
- Copy data from strictly-protected sheet
- Copy and Paste can do so much...
- Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
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 