Hi All,
I would like to create VBA code for split a long text (items) into multiple columns as below picture (How to split the items) by using column button (Split Text)
I used the code below but it didn't work while I was using it.
Sub splitText()
'splits Text active cell using ALT+10...