Improve company productivity with a Business Account.Sign Up
Selection.TextToColumns Destination:=Selection.Cells(1, 1), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 9), Array(3, 4)), TrailingMinusNumbers:=True
Open in new window
The problem with the text to columns using a fixed type, is that the 1-9 dates do not have a zero before them so the fixed length is different.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.