Download Excel File: [ Ссылка ]
Learn how to remove number digits from Text in a Cell using Flash Fill, Power Query M Code Function, Microsoft 365 Excel Worksheet Formula, LET Function, Old School Formula (if it is possible?).
Topics:
1. (00:00) Introduction
2. (00:21) Flash Fill, considering how we select correct example to get Flash Fill to work.
3. (01:36) Power Query M Code Function. Look at Text.Remove Power Query M Code function and how to generate a list of text numbers.
4. (05:24) Microsoft 365 Excel Worksheet Formula. See the functions: LEN, SEQUENCE, MID, ISERROR, FILTER and CONCAT.
5. (08:25) Is an Old School Formula possible? Consider More Func Add-in in earlier versions and the MCONCAT Function.
6. (09:00) LET Function. Use LET when you have formula elements repeated in your formula. This leads to more efficient calculation by the Excel Calculation Engine.
7. (11:37) End Video Links
Ещё видео!