[Affiliate]
Blog Stats
- 3,299,709 hits
-
Join 3,248 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?
- Dropdown calendar in Excel
- Perform VLOOKUP with 2 lookup values
- Open an embedded Excel file during a slide show in PowerPoint?
- 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
- Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
- Time Conversion - How to convert 24hr input as 4-digit number into TIME in Excel?
- SUM vs. SUBTOTAL
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: SEARCH
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
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
Make impossible possible
Convert text of specific pattern like “1d 2h 3m 4s” into real time (26:03:04) in Excel To kick start the Year of Monkey, let’s challenge the apparently impossible… Do you think it is not possible in Excel? If you do, you … Continue reading
wmfexcel 