close

I need to concatenate text from 4 cells so that in the final string the text
from each cell is padded up to a length of 40 characters.
any ideas?
--
john

=left(a1amp;rept(quot; quot;,40),40)amp;left(b1amp;rept(quot; quot;,40),40) amp; .....

If you have numbers/dates, you may want:

=right(rept(quot; quot;,40)amp;text(a1,quot;mm/dd/yyyyquot;),40) amp; .....

john dunford wrote:
gt;
gt; I need to concatenate text from 4 cells so that in the final string the text
gt; from each cell is padded up to a length of 40 characters.
gt; any ideas?
gt; --
gt; john

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄