# Tag Archives: Find and Replace

## Adding bullet to each line in cell

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

## Transpose Data (Static and Linked)

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

## 5 Little Excel Tips (tests)

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

## F5 – It is the key I rarely press

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

## SUM Time in the end of text strings

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

## Sum a range of number end with “k”

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 | | 2 Comments

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

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