https://community.blueprism.com/t5/Product-Forum/Put-text-into-columns-based-on-a-delimiter/m-p/73212#M25817 Hi,  I am trying to pass some data that I have either in a Collection or a Data Item that is separated by a "^" I was using the the "Split Text" Action but it does not work for me, because it puts the separated text in new rows and I want it in new columns. Is there a way to do this. This would as if you would be doing it in Excel in the "Text to Columns" buttom. Thanks! Tue, 27 Feb 2018 21:45:00 GMT EdritFranquiz 2018-02-27T21:45:00Z https://community.blueprism.com/t5/Product-Forum/Put-text-into-columns-based-on-a-delimiter/m-p/73212#M25817 Hi,  I am trying to pass some data that I have either in a Collection or a Data Item that is separated by a "^" I was using the the "Split Text" Action but it does not work for me, because it puts the separated text in new rows and I want it in new columns. Is there a way to do this. This would as if you would be doing it in Excel in the "Text to Columns" buttom. Thanks! Tue, 27 Feb 2018 21:45:00 GMT https://community.blueprism.com/t5/Product-Forum/Put-text-into-columns-based-on-a-delimiter/m-p/73212#M25817 EdritFranquiz 2018-02-27T21:45:00Z https://community.blueprism.com/t5/Product-Forum/Put-text-into-columns-based-on-a-delimiter/m-p/73213#M25818 Try This  Dim RR As Object Dim excel As Object Try RR = GetWorksheet(Handle, WorkBookName, WorkSheetName) RR.Activate() excel = RR.Application RR.UsedRange.Select() excel.Selection.TextToColumns (DataType:=1, ConsecutiveDelimiter:=True,Other:=True,OtherChar:=Delimiter) Success = True Catch e As Exception Success = False Message = e.Message End Try Fri, 23 Mar 2018 11:02:00 GMT https://community.blueprism.com/t5/Product-Forum/Put-text-into-columns-based-on-a-delimiter/m-p/73213#M25818 RakeshReddy 2018-03-23T11:02:00Z