[Affiliate]
Blog Stats
- 3,268,879 hits
-
Join 3,244 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Dropdown calendar in Excel
- Perform VLOOKUP with 2 lookup values
- About
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Calculate number of "*day" in a given period
- =SUM('???'!C3) Is it a valid formula?? No. It is magical indeed!
- Time Conversion - How to convert 24hr input as 4-digit number into TIME in Excel?
- The amazing SUMPRODUCT
- Sequential number for visible rows only
- Combine contents in a range of cells into a single cell, with no VBA nor formula.
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Symbol
Go to Special + Copy and Paste do the magic
Answer to the 5 little Tips (tests) – Part 4/5 The task: To convert “1” to “Tick” in a table like the following one: Answer: Copy and Paste with a simple trick … What? Not Find and Replace? Yes, you may do it by using … Continue reading
Insert “tick in a box” in Excel
Recently, I’ve been collecting Excel files from colleagues regarding implementation status of some activities in the region. Part of the template looks like the screenshot below: Quite simple and straight forward, right? I expected I would get something like the following in … Continue reading
Input special characters in Excel by pressing Alt + Numpad
Perhaps you know that you can input some special characters/symbols by pressing Alt + Numpad together. If you google “ALT Numpad”, you will probably find many extensive lists of special characters input in this way. Well, what to do with … Continue reading



