Tag Archives: Trim

Trim like #Excel in #PowerQuery

Posted on May 9, 2022 by MF

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 , , , , | 6 Comments

Fixing inconsistent data type in lookup table in #Excel

Posted on December 11, 2021 by MF

A common VLOOKUP problem with an easy fix The situation – VLOOKUP fails… Have you ever encountered something like this? This is quite common. We are sure that the VLOOKUP formula is correct. We are sure that the lookup values … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | 2 Comments

How to remove leading space in #Excel

Posted on May 10, 2018 by MF

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 →

Rate this:

Posted in Formula | Tagged , , , , | 2 Comments

Text manipulation with Excel functions

Posted on July 23, 2016 by MF

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 →

Rate this:

Posted in Formula | Tagged , , , , , , , , , , | 6 Comments

Extract last word from a text string

Posted on November 17, 2014 by MF

There are many cases that we may just want the last word from a text string.  Typical example would be something like the last row in the above screenshot: There are many codes at the end of a text string … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 5 Comments

Advanced vlookup – Text vs. Number

Posted on January 8, 2014 by MF

Why does vlookup not return the lookup value? I am sure it is in the source data table.  I see it by my eyes. Have you ever experienced this?? That’s normal when you import your data from other database.  Fortunately … Continue reading →

Rate this:

Posted in Formula | Tagged , , | 14 Comments