Splitting String By User Choice
Split String With Excel Vba
Inputbox opens when the button in page is pressed.You can write in the inputbox, which delimiter will be used for splitting .
The results are listed in column A. Total number of splitted data are displayed on msgbox.
Also when entering data in cell D1, the wrap-text function works and the cell height is set ,cell D1 width not change.