How to add space between text in excel cell - after N characters

[@ExcelTipsVideos]

Check out our playlist on Excel Graphs by clicking on : ruclips.net/p/PLI_LFffUJS09cqZYimxRUwrYd1lwyGkzk

[@SunitaSharmaA]

FINALLY! DONE... THANKS.

[@missme1794]

Thank you so much! This has helped me to resolve a problem I was really stuck on.
Best wishes ❤ 🙏

[@guruduttphadke8291]

Nice video; This really helped my work

[@ExcelTipsVideos]

Glad it helped

[@Afternooninalaskaandindia]

What is $1$4 please explain ?

[@ExcelTipsVideos]

$I$4 is the number of characters from the right where you want to split the text --> In the above scenario, it is @

[@sstarstruck9495]

Omg the guy is just rambling on! 😖

[@tuannuramaninat.m.nawawi5068]

ure talking without showing how it is done. it didnt really helped me.

[@ExcelTipsVideos]

In this video, I explain how the formula is developed - writing out the formula would have made the video longer - can you see if you can follow along by writing the formula that I explain - pausing the video when you need some time?