Hi all

I wondered if anyone could help with a query I have? I have a userform which users will fill in with generic information. One of these fields is to enter a national grid reference (i.e. 'SE 12345 12345').

This NGR should always be entered as two letters (SE) then a space and then either 4 or 5 numbers, then a space and then again 4 or 5 more numbers. The amount of numbers depends on how accurate we need the NGR to be and varies case by case.

I'm trying to add a code in which will automatically convert 'SE1234512345' or 'SE12341234' so that they are correctly spaced. However I have no clue how to do this, or if it's even possible.

Anyone have any ideas?

Thanks in advance!

Antony