Is it possible to repair the VGA connector on the back of a computer monitor?

I just got a new monitor, put it in the trunk of my car, and drove off without realizing that the vga cable was dangling out the end. By the time I found out, it had been hopelessly deformed by hitting against the road. The other end of the cable is hardwired into the monitor. Is there any (cheap) way to fix this? Does anybody sell replacement vga plugs? I could lop off the dead plug and solder a new one on, but I neither have a new plug nor do I know which wires to connect where.