Power Query Basic 10 - Extract from a column
It is a common task to extract certain texts from a cell in Excel. For example, we may want to get the length of the cell content, extract the first or last N characters, extract the text in a range, or even a portion of text that is before/after or even in-between specific delimiters.
If you are good in Excel formula, you may be able to achieve this by constructing formula with Excel functions such as LEN, LEFT, MID, LEFT, etc. For simple scenario, it works fine. Nevertheless, let's face the fact that not everyone is good at writing Excel formula. Also, we must admit that there are some scenarios where only "complex" formula can help.
Unbelievably, with Power Query we don't need to write a single formula to extract values from a column under many different circumstances. Most of the task can be done via User Interface. You will see it in the video!
You may download a sample file from my blogpost to follow along.
https://wp.me/p3T315-5gM
#excel
#powerquery
#extract
In questa pagina del sito puoi guardare il video online Power Query Basic 10 - Extract from a column della durata di ore minuti seconda in buona qualità , che l'utente ha caricato wmfexcel 01 ottobre 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 652 volte e gli è piaciuto 16 spettatori. Buona visione!
