Addition of data based on condition

[Gsiva3]

Hi all,

I have a input column named Description. 

My concern is, whatever the length of Description might be but the output of the length of description should be 40. For example, in the input what I have attached, the length of "A4 cell" is 14 but my expected output is 40 characters. Hence the difference here is (40-14=26). So these 26 characters I need as  "*" in the separate column as mentioned in output sheet which is attached below. Is there any possibility for this.

Please help me with this. Herewith I have attached the input & output sheet.

[Qiu · Accepted solution]

@Gsiva3 

Something like this?

[grazitti_sapna · Accepted solution]

Hi @Gsiva3 , give this a try.

I hope this works, kindly mark this post as solution.

Thanks.

[atcodedog05 · Accepted solution]

Hi @Gsiva3 

Adding a little bit of background explanation to @Qiu 's and @grazitti_sapna 's solution.

Since in your case padding needs to done on empty string. Both padLeft or padRight can be used.

Hope this helps 🙂

[Qiu]

You might become a good teacher.😁

[Gsiva3]

Hi @Qiu 

Thank you so much. Got it!!!