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
Auf dieser Seite können Sie das Online-Video Power Query Basic 10 - Extract from a column mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer wmfexcel 01 Oktober 2022 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 652 Mal angesehen und es wurde von 16 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
