Trasmission Swap

Just curious if anyone has ever swapped an automatic with standard transmission, or knows a good place to find info on it? I have a 98 civic lx, its auto, either gonna switch or just sell and get a new 5 speed. Friend told me its prolly better just to get a new car, but if I can keep mine and switch I'd be willing to do it. Any suggestions? Thanks!