How to use Text to Columns activity

[li.yu (Penny)]

Thanks John, I know how to use it now, ExcelFileName.Sheet(“SheetName”).Range(“C:C”), this would help. And BTW, we can use formula too refer to Delete txt file row character starting with ! and use "Text to column" with delimiter! - #5 by NIVED_NAMBIAR