close
With data in A1, in B1 put=TRIM(MID(A1,FIND(quot;:quot;,A1) 1,255))
copy down
quot;sazizquot; wrote:
gt;
gt; Hi,
gt; I got a sheet where I need to delete number followed by ':'. All these
gt; numbers are at the left in a cell like this---gt; 300: text.... few
gt; hundred rows. Any help please?
gt; Aziz
gt;
gt;
gt; --
gt; saziz
gt; ------------------------------------------------------------------------
gt; saziz's Profile: www.excelforum.com/member.php...foamp;userid=6350
gt; View this thread: www.excelforum.com/showthread...hreadid=536939
gt;
gt;
全站熱搜
留言列表
