Deleting text from cells with macro

[pocoloco]

I am trying to delete common text from multiple cells in a worksheet. I am not real familiar with VBA but know there is probably a way of doing this via a macro. This is the common data that starts off every cell.

9/2/2008 12:06:28 PM (ERROR)

So basically I am looking to delete everthing from the beginning of the cell to the " ) " character. Any help or advice would be greatly appeciated.

Pocoloco.....

[rylo]

Hi

You can do an edit replace without the need for a macro. Any reason that you can't use that facility?

rylo

[Leith Ross]

Hello pocoloco,

Here is macro that will remove the beginning text from cell up to the ")" in column "A" on the active sheet.

Please Login or Register  to view this content.

Sincerely,
Leith Ross