What sivagelli is trying to suggest is correct. Even though it appears in a straight line in the data item it actually has a new line character between them as seen in a hex editor which is same as your input text in your initial posts.Hi VJR,
The second scenario you showed was the situation I'm having trouble with now.
How can we un-wrap the text in excel in Blueprism?Hi soginiski,
Be noted that even if the text in my cell looks to be on multiple lines, it is actually one single line in the top Formula Bar.
View attachment 2506
This is because I have enabled 'Wrap Text' for cell A1 in the Format cells and have decreased the width of Column A such that it shows up on three different lines.
So check if that's the case with you.
Now I have removed the Wrap Text and written the text in Cell A1 on three different lines using an Alt Enter for the new line, in which case it shows up exactly the same in the Formula Bar too.
View attachment 2507
The text in the Formula Bar could be the one that ends up in the 'Get cell value' return data item.