I have a line of code for text to column with comma as the delimiter.

ws.Columns(1).TextToColumns Destination:=ws.Range("A1"), DataType:=xlDelimited, comma:=True

A month ago this was working as expected. Although now it also appears to be including space as a delimiter.

For example, when it was working the following text:

text to column start.JPG

would be converted to:

text to column correct.JPG

Although now it appears to be also including space as a delimiter and is converting it to:


text to column incorrect.JPG


Why is it all suddenly including space as a delimiter? has there been any updates which would default the space delimiter to True?

Should I also include space:=false in the code?



Regards

Glenn