Put text into columns based on a delimiter

[EdritFranquiz]

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!

[RakeshReddy]

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