[Affiliate]
Blog Stats
- 3,288,629 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Show number in thousand (k) or in million (M) by using custom format
- Perform VLOOKUP with 2 lookup values
- Sequential number for visible rows only
- Open an embedded Excel file during a slide show in PowerPoint?
- Dropdown calendar in Excel
- Rename column names in a dynamic way with #Excel #PowerQuery
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- SUM vs. SUBTOTAL
- The INDIRECT trick of using Structured Reference in Conditional Formatting
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Text.Trim
Trim like #Excel in #PowerQuery
In Power Query, there are some functions that are very similar to Excel, which you expect the same results from them. However, it may not be the case because they indeed perform differently. TRIM is one of them. TRIM is … Continue reading →
Rate this:
Posted in Power Query
|
Tagged List.RemoveItems, Text.Combine, Text.Split, Text.Trim, Trim
|
6 Comments
wmfexcel 