Tag Archives: Split Cell

Split date ranges from cells with #Excel #PowerQuery

Posted on May 10, 2020 by MF

Take a look at the challenge presented above.  Is it possible to do it in Excel? Be honest, without Power Query, I have no idea how to do it but manual work. 😁🤦‍♂️ Believe it or not, with Power Query, … Continue reading →

Rate this:

Posted in Power Query | Tagged , , , | Leave a comment

Split cell contents separated by line feed into rows with #Excel #PowerQuery – Part 2

Posted on May 13, 2019 by MF

Last week, I showed you how to split cell contents separated by line feed into rows with Power Query.  That was easy when we are dealing with only one column.  If you don’t know how, you may read the post … Continue reading →

Rate this:

Posted in Excel in Action, Power Query | Tagged , | 5 Comments

Split cell contents separated by line feed into rows with #Excel #PowerQuery

Posted on May 4, 2019 by MF

After an in-house training, a colleague came to me and asked if there is a way to do the following: The problem here is the contents in cells are separated by a line feed (line break).  A cell may contain … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment