Excel Power Query - Split and Loop text in a cell using Function. NO VBA | XL Studio | #xlstudio

Показать описание

Hi Guys, Welcome back !!

If you want to know how we can loop through each character in a cell or want to know how we can split text based on any delimiter by using just Excel function without using any VBA Code then this video is for you.

Please watch the entire video to understand the logics in step by step to do this complex logics in easy way.

In this video you can learn new Office 365 dynamic arrays functions like SEQUENCE and LET and also deep learning on SUBSTITUTE function, using this you no need to write any VBA Code.

LET Function

Jump to the specific solution here by clicking on below timestamps

0:00 - Start of the Video
1:20 - First approach Power Query Solution
8:19 - Second approach Excel Function Solution
11:23 - Function logic to get Total Product Count
19:08 - Function logic to Loop through text and Total amount
29:20 - Entire logic in a Cell using LET Function

==================================================
Please do like the video and subscribe to my channel and hit the bell icon to get notified with my upcoming videos

Thank you so much for Watching !!!
==============================================
XL Studio | #xlstudio #let #sequence #substitute #search #search #mid #value #sum