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.
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.