If : only occurs once per cell, select the column, do datatext to columns,
select delimited and click next, select other and put : in the other box,
click next, select the left column in the data preview (should be black)
which is the default, then select do not import (skip) and click finish

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"saziz" wrote in
message ...

Hi,
I got a sheet where I need to delete number followed by ':'. All these
numbers are at the left in a cell like this--- 300: text.... few
hundred rows. Any help please?
Aziz


--
saziz
------------------------------------------------------------------------
saziz's Profile:
http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=536939