How to remove white space in excel cell

Help StudioX
, , , , , ,
1

Hi,

I am converting data table into string using output data table and writing that string in excel. But when it is pasting in excel cell it is taking lot of space (white space).how can i remove this blank space?
check this screenshots
1

2
2765×367 13.6 KB

Kindly help me for the same.

2

Hi @Mathkar_kunal,

Perhaps within the Write Cell, you could try to replace “finalstring” with finalstring.Replace(",,","")

Hope this helps
Best regards,
Marius

3

@Mathkar_kunal, Use finalstring.Trim in write cell and check.

2 Likes
4

Trim work little but still there is some space .
1

because of column AH.Because i am pasting string in AH.

5

Not working

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.