Space Issue in Read Cell and Concate it

Help
1

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
2

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

1 Like
3

Screenshot%20(10)
Screenshot%20(10)1360Ă—768 89.2 KB

4

I hope you don’t have spaces in excel.

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

5

Screenshot%20(11)
Screenshot%20(11)1360Ă—768 97 KB

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

6

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” …