close

Hi,

I need help to include this formula: =MID(TRIM(A7),12,20) into a existing
VBA procedure.

I need to run the procedure in Column C for all the names in Column B

Thank you,
--
Regards,
JeffTo get rid of extra spaces within the text

Sub trimit()
x = Mid(Application.Trim(Range(quot;a7quot;)), 3, 6)
Range(quot;f4quot;) = x
End Sub
--
Don Guillett
SalesAid Software

quot;Jeffquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I need help to include this formula: =MID(TRIM(A7),12,20) into a existing
gt; VBA procedure.
gt;
gt; I need to run the procedure in Column C for all the names in Column B
gt;
gt; Thank you,
gt; --
gt; Regards,
gt; Jeff
gt;

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

    software

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

    E-mail轉寄