I need to dynamically convert parts of a spreadsheet to columns. I used a macro to get the following syntax:
Selection.TextToColumns Destination:=Range("A7"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(11, 1), Array(24, 1), Array(37, 1), Array(50, 1), _...