Tag Archives: Find and Replace

Replace values in Power Query

Posted on June 19, 2022 by MF

Find and Replace is quite common in Excel. If you are not sure about what options we have for Find and Replace, please read my blogpost here. In regular Excel, the Find and Replace action is one-off. Whenever we have … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment

Understanding Find and Replace in #Excel

Posted on September 19, 2020 by MF

Find and Replace is a very handy tool in Excel. It helps you to find a value quickly. You may then replace the value found with another value, either one by one or replace all at one batch. To use … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

Replace blanks with zero in #Excel

Posted on May 2, 2020 by MF

Following the techniques used in the previous post , we can perform many Excel magics for different scenarios.  On top of my mind is to replace blank cells with zero.   The first task is to select all blank cells in … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , | Leave a comment

Adding bullet to each line in cell

Posted on April 16, 2017 by MF

Does it sound familiar to you? Are you using Excel as word processing tool? If you have experienced the task shown above, you should know how tedious and time-consuming it could be as you cannot convert each line into bullet … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments

Transpose Data (Static and Linked)

Posted on January 14, 2017 by MF

Answer to the 5 little Tricks posted in the beginning of the year – Part 1/5 Transpose Data – Result is static This is actually a simple trick of using Copy and Paster (Special, Transpose).  See? It can be done in a … Continue reading →

Rate this:

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

5 Little Excel Tips (tests)

Posted on January 7, 2017 by MF

First of all, Happy New Year of 2017!  Wish you all an Excellent year ahead! Let’s start the year with a simple “Game” which I developed for in-house Excel training in my previous company.  All participants were expected to have basic Excel knowledge. … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment

F5 – It is the key I rarely press

Posted on September 30, 2015 by MF

The working combinations for F5. F5 alone – Open the Go To Dialog box Ctrl+F5 – restore the window size of the selected workbook Shift+F5 – Open Find (and Replace) Alt+F5 – Refresh Pivot Table Ctrl+Alt+F5 – Refresh All Nevertheless, … Continue reading →

Rate this:

Posted in Shortcut | Tagged , , , , | Leave a comment

SUM Time in the end of text strings

Posted on July 25, 2015 by MF

Did you encounter a task like this?  I did.  Actually it is not as difficult as you may expect.  It could be done in just a minute IF the data is not too bad, like the one shown above. I … Continue reading →

Rate this:

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

Sum a range of number end with “k”

Posted on April 11, 2015 by MF

Does it sound familiar to you? If you are having this kind of issue all the time, you may want to continue reading this as I am going to show you three different approaches to fix the problem. Non-Formula approach Formula … Continue reading →

Rate this:

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

Combine contents in a range of cells into a single cell, with no VBA nor formula.

Posted on November 22, 2014 by MF

  Well, the first thing in your mind maybe using ampersand &  or CONCATENATE to combine them. =A1&” “&A2&” “&A3&” “…… =CONCATENATE(A1,” “,A2,” “……) which is more or less time consuming. Two ways to achieve this quickly Using a combination of … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments