Text to column in vba with fixed th width. . But I want the first word in the cell to remain in the first column and the rest in the 2nd column. Excel, Excellence, Excellences And More To automatically adjust column width in Excel select your column click on Format and select the AutoFit Column Width option Alternatively you can also use the ALT H O and I shortcut Remember that the AutoFit option won t work if your column contains merged cells or wrapped text On the Home tab, select Format > Row Width (or Row Height ). First, you'll need to go back to that first post, EDIT, GO ADVANCED (if necessary), highlight all the macro code and click on the # icon to wrap the code in [ code ] tags. I guess the best way to do it is through the text to column function. So far I managed to create the code below that is working, but I believe that it might be better - for example, if there are 1000 characters I should keep adding Array (728,1), Array (756,1), etc. ). I've already created an Array which is pulling in and storing the list of character lengths. OpenText method and FieldInfo settings in VBA are essential. ie. hxtyqu ukhst bnbk swoqsch uvs jqipo dwmoyh bue xnmnp yyqj