Solved: Microsoft excel deletion macro?

james@creative · 15-Apr-2009, 10:04 AM #1

Dear Tech Guys I hope can help as thought of manually deleting all this data is making me lose the will to live.
I need to delete all data contained within brackets
Example
Audrey Fletcher-price (creative director)
Yucca Tong (General Manager)
Steve Parkhouse (studio manager)
Peter Edwards (head of production)

Can you create a macro in visual basic for this?

Zack Barresse · 15-Apr-2009, 04:16 PM #2

Hi there, welcome to the board!

Sure there is. And here ya go...

Code:

Sub ClearData()
    Cells.Replace What:=" (*", Replacement:=""
End Sub

Edit: Of course you could do this using regular Replace from the Edit menu.

HTH

james@creative · 16-Apr-2009, 05:36 AM #3

worked like a dream

Tag Cloud
access acer asus bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory monitor motherboard network printer problem ram registry router security slow software sound toshiba trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless xbox

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!