With data in A1, in B1 put


=TRIM(MID(A1,FIND(":",A1)+1,255))

copy down

"saziz" wrote:


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