How can I eliminate spray paint odor?
The reason for the smell is because of the VOC (Volatile Organic Compounds) content in paint.


  The best way to avoid breathing in paint fumes is to not have them to begin with. Most indoor and outdoor paints contain volatile organic compounds, or VOCs. These compounds are ingredients in the paint and are responsible for the odors emitted as the paint dries. Low-VOC paint is commonly available. It has less of an odor and is safer for both you and the environment. (Source)


Whether there are low-VOC paints in spray cans I don't know.

There is a cheap and environmentally friendly way to remove the fumes provided by Greenopedia.


  Salt, lemon and vinegar all have the power to soak up paint smells pretty quickly. And because you’re absorbing the chemicals instead of pushing them around with a fan, they won’t linger in your air ducts or spread to other parts of the house.


Another idea is using onions, as suggested in the link above.  Cut them in half and put the halves around the house or cut them into small pieces into bowls and add some vinegar.


  
  Grab some bowls and fill them halfway with water.
  Add a few slices of lemon and/or a quarter cup of salt to each bowlOr instead of lemon &amp; salt, fill a few bowls halfway with vinegar.
  Place the bowls around the room and let them sit overnight or until the paint smell is gone.
  Rinse the salt water or vinegar down the sink and discard lemons in the trash or compost.Do not eat or drink them.
  


The reason why you MUST NOT eat them is because they will become toxic.  They will contain paint solvents as the salt water, vinegar and lemons will have absorbed them.