Hey guys,

I'm new here (However my friend assures me this is the place to come for excel problems and insists you are all geniuses) so apologies if this is in the wrong place but with my limited experience with excel I figured VBA would probably be the best way to do this?

Basically I have a column full of phone numbers that are in varying formats and I need them all in the same format. This is made more complicated by the fact that not all the numbers are UK numbers or even the same length, however a majority are and are currently displayed as either;

+ 44 XXXX XXXXXX
+ 44 XX XXXXXXXX
+ 44 XXX XXXXXXX

Then a range of weird and wonderful other combinations.

and they need to be displayed as;

+ 44 XXX XXX XXXX

If I could get at least the above formats to convert to the way I need them to be displayed then I could do the few remaining manually but it would help massively.

Is VBA the best way to do this? If so where do I start? (I'm relatively new to Excel, let alone VBA)

Thanks a lot guys!