Remove leading zeros and keep trailing ones

[Moxioron]

Hello all.

I have this formula:
=IF(S6="X",LEFT(E6&", "&C6&" "&D6&REPT(" ",30),30),"")

Works great except some of the fields have one or more leading spaces. I tried TRIM. However, that removed all of the trailing spaces and I need the field to be exactly 30, which means of course I have to keep the trailing spaces.

Where am I going astray? Thank you.

 

[Tetra201]

Maybe

=IF(S6="X",LEFT(TRIM(E6&", "&C6&" "&D6)&REPT(" ",30),30),"")

 

[Moxioron]

Thank you so much. That did the trick. Like a moron, I had the TRIM at the start of the expression.

Appreciate it!