https://youtube.com/watch?v=xcVLWyEJHwYUntil now, splitting words to separate cells or breaking up long text strings in Excel using a delimiter was quite a challenge. We had to use functions like LEFT, MID,…