Space Issue in Read Cell and Concate it

i used read cell activities stored its output in diff variables and assign one variable to concate all read cell output but when its concate it removes space and combine

1 Like

Can you share the workflow or screenshot of your activities? @Sushant_Chanakhekar

1 Like

I hope you don’t have spaces in excel.

You can give it as " " + IN1 + " " + and so on… to get spaces …

in above form insured name is given i extract it by using read cell and combine it but the spaces between first name ,middle name and last name get removed automatically while combining

That cell values are reading as null instead of space @Sushant_Chanakhekar,
So, it won’t be treated as space. They are just null or String.Empty …

So, try to use If condition such that If string is null or string.Empty then take it as “Space” …