macro to delete all text after colons

[Orzabal]

Hello everyone! I have what I hope is a simple request...

I need a macro that finds all instances of ":", and deletes the colon along with all text after it within each cell. For example, if Column A reads:

Please Login or Register  to view this content.

...then, after running the macro, it should read:

Please Login or Register  to view this content.

Your help is appreciated!

[sweep]

Hi,

Are you sure you need a macro?

Much easier like this,

=LEFT(A1,(FIND(":",A1)-1))

[Orzabal]

Please ignore me, for I am an idiot. About two minutes after posting this, I smacked myself upside the head and ran a Find-Replace for ":*" and "[blank]". Mission accomplished. Thanks anyway.