Monthly Archives: November 2017

Insert a text string into a specific position of another text string in #Excel

Turn REPLACE function into “INSERT” function Continue reading

Rate this:

Advertisements
Posted in Formula | Tagged , | Leave a comment

#Excel Humor #12 – Power Voice

Did you experience the Power Voice for #Excel?   Like this post if you did.   😛

Rate this:

Posted in General | Tagged | Leave a comment

Data transformation with Power Query

Transform date input as “Excel-unrecognized” text string into date (number) usable by #Excel This is a continuation of the previous post – How to turn “1st January, 2017” into #Excel recognizable date?   …using Get & Transform (better known as #PowerQuery). Note: … Continue reading

Rate this:

Posted in Power Query | Tagged , | Leave a comment

How to turn “1st January, 2017” into #Excel recognizable date?

Quite a long time ago, I wrote a post to discuss a trick to format date with “st”, “nd”, “rd”, etc… In this post, I am going to discuss the reversed way: Turning an English written date with “Dst MMMM, … Continue reading

Rate this:

Posted in Formula | Tagged , , , , , , | 8 Comments