close

i want to convert telephone number to regular number

FORMAT, CELL, GENERAL

quot;JMBquot; wrote:

gt; If your data is in cell A1, enter this in B1 and copy down, then you could
gt; copy/paste special values.
gt;
gt; =--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,quot;(quot;,quot;quot;),quot;)quot;,quot;quot; ),quot;-quot;,quot;quot;)
gt;
gt;
gt;
gt; quot;buccigquot; wrote:
gt;
gt; gt; i want to convert telephone number to regular number

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

    software

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

    E-mail轉寄