[Affiliate]
Blog Stats
- 3,289,699 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Show number in thousand (k) or in million (M) by using custom format
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- #Excel Add current selection to filter. What it does?
- Calculating CAGR with Goal Seek in #Excel
- SUM vs. SUBTOTAL
- Learn how to build effective #Excel Dashboard from Mynda Treacy
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Copy data from strictly-protected sheet
- Change the first letter to upper case, first word only please #Excel
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: CHAR
How to remove leading space in #Excel
When TRIM and CLEAN do not work… Is it something bothering you? To fix this problem, we need to understand where is the “leading space” coming come. Before we jump to that, I want to show you two Excel functions … Continue reading
wmfexcel 