- 2,634,836 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- Be cautious when using XLOOKUP
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Filter a list of items from a long long list
- When unhide row doesn't work...
- Open an embedded Excel file during a slide show in PowerPoint?
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
My YouTube Channel
- My Tweets
Tag Archives: FIND
Find and Replace is a very handy tool in Excel. It helps you to find a value quickly. You may then replace the value found with another value, either one by one or replace all at one batch. To use … Continue reading
In the previous blog post, we see how Flash Fill extracts First Name and Last Name from an email address in a format shown above. I’ve also recorded a video for that post. Flash Fill is so smart to detect … Continue reading
Got the following question: hi, how do i search for a specific combination of characters exclusively i.e. if one cell contains 5A;3B&4C while another cell contains 5AA;3B&4C, and my search criteria is 5A, i want the results to return only … Continue reading
Writing a long formula is not easy, even for an advanced Excel user. What I mean long is a formula with many nested FUNCTIONS within a single formula. The difficulty I am talking about is not related to whether you understand the … Continue reading
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
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
The working combinations for F5. F5 alone – Open the Go To Dialog box Ctrl+F5 – restore the window size of the selected workbook Shift+F5 – Open Find (and Replace) Alt+F5 – Refresh Pivot Table Ctrl+Alt+F5 – Refresh All Nevertheless, … Continue reading
Extract number from a text string This post is about two things: How a poor system set up could drive you crazy? Why being good in Excel could save you lots of time in workplace? Another real work example. I was … Continue reading
Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques. I had encountered a file with thousands of records (rows) that keeps track of details of different jobs. Finished jobs were identified by Strikethrough … Continue reading