How to add space between text in excel cell - after N characters
In this video, we will look at How to add space between text in excel cell. We will look at how to add space after N Characters - both from the Left and the Right.
Click here to subscribe to my channel to get more videos of Excel formula tips and uses:
/ @exceltipsvideos
add space between text in excel cell formula:
Left Split Formula:
=LEFT(B2,$I$3) & $I$5 & RIGHT(B2,LEN(B2)-$I$3)
Right Split Formula:
=LEFT(E2,LEN(E2)-$I$4) & $I$5 & RIGHT(E2,$I$4)
Check out our Excel Graph Playlist :
• Excel Graphs