Hi all, I am storing a value as a variable out of an excel cell but I am not getting the complete value I am using it further in my workflow and it then only shows “R. Storrs” while it should show “R. Storrs_EMC_AR_65208_ENQ_Nov18” . As you can see below I have a break line in it. I already tried …

Or probably you can try changing the vbCrLf with other constants like vbLf, vbCr, vbVerticalTab. Please share the outcome.

Remove the break lines

Dominic (Dominic) November 8, 2018, 2:13pm 2

Please refer the below post and use vbConstants

Topic		Replies	Views
How to delete a line break Help excel , activities , studio	5	12618	October 29, 2018
Split a a string based on new line Help activities , string , question , data_manipulation	5	10828	January 16, 2020
Split on Dynamic Identifier Help	14	3310	September 14, 2017
Separate String on newlines in Excel Help excel	11	2655	October 20, 2019
Delete new line and unwanted space Help studio	11	9007	April 1, 2019