Disposition of a string in a file horizontally

[CamiCat]

Hi,
I have a problem with the disposition of a string in an Excel sheet.
I attach a picture of how I extract a string from a txt file into an Excel Sheet
The string in the txt file is:
Sinistri resp. principale

0

0

0

0

00

00

Is there a possibility to save the string horizontally in the Excel sheet?
Or maybe is there a possibility to extract the text from the txt file so that it is in an horizontal disposition, not in a vertical one?
Thank you,
Camilla.

[Dominic]

@camicaT, Lets say you have stored the value from excel into a string variable (strVerticalValue) that contains

@CamiCat

0

0

0

0

00

00

ASSIGN
strHorizontalValue = String.Join(" ",strVerticalValue.Split({Environment.NewLine},StringSplitOptions.RemoveEmptyEntries))

Note: Kindly refer our forum posts before you ask that gives you more than what you expect

Regards,
Dom

[CamiCat]

Thank you so much @Dominic.
It solved my problem.
Regards,
Camilla.