Hi, I had this done before Christmas and though the thought of what you are having done is scary the actual procedure itself is not too bad. Depending on how much cervix they decide to take will decide on the pain relief they give you. I had a lot [almost all of mine removed] so had a local anaesthetic directly in to the cervix ..... not a nice feeling but not as painful as you imagine.
Try not to panic, these are just abnormal cells and this will usually be enough to sort out the issue. The hospital that treated me were amazing and told me everything I needed to know before the procedure. I was in little to no pain afterwards but did need to wear a sanitary towel for a few weeks. After that it's just a matter of waiting for your results. Fingers crossed this will just mean regular check ups for a while.
Good luck
Lisa x