How to use Text to Columns activity

[Blaker_John]

This is how it looks in StudioX. I don’t know about Studio.

Regardless I think its a formatting issue with how you are indicating the column. ExcelFileName.Sheet(“SheetName”).Range(“C:C”) is the formatting in the Advanced Editor. It’s probably not able to figure out what column you want to select as the source because you dont have the File Name and Sheet Name parameters in your current formatting.

That’s what the formatting looks like in StudioX. I would assume the language would look the same in Studio.