close

I am trying to match the beginning of a text string in a cell, so that I can
replace a character only at the beginning and not anywhere else. I have done
this with regular expressesions, such as ^ in the past. Is this possible in
Excel?

=left(a1,1)quot;David Greggsquot; wrote:

gt; I am trying to match the beginning of a text string in a cell, so that I can
gt; replace a character only at the beginning and not anywhere else. I have done
gt; this with regular expressesions, such as ^ in the past. Is this possible in
gt; Excel?

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

    software

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