If it's from snorting shit, try putting an ice cube on a saucer, and snort a little of the melted water from it.
You wanna know what really burns? My grandmother told me that snorting pepper helps unclog the nose when it's stopped up. So I tried it one time and it worked, but goddammit it hurt so fuckin bad.
Your grandmother told you to snort pepper? Haha man your grandmother is a cool lady. But yea the burning will go away, just takes time, put a little bit of water up there and your cool.