code for seperating alpha numerics
 

Hi,
I have a long list with a date and event (about once sentence long)
all this is in one cell in a sheet.
I need to seperate from col A, date/(sometimes number with:) and put
text in col B. Could there be a short code pls?
Thanks
Aziz


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