I have a table with 100's of cells and I need to do a search for a colon ( : ) and then delete it and everything to the right of it in that cell. I can not figure out what wild card sequence to use in the advanced search and replace dialog. Can a more experienced person lend a helping hand please.

Many thanks,
Houston