I have a large number of UK postcodes without any spacing. The correct format requires a space before the last 3 characters of the postcode. Postcodes vary in length from 5 to 7 characters. However I believe the format always has 3 characters at the end as a constant eg CV34 7RH, CV5 7RH, C1 7RH. I am able to seperate the charactors in a text string using the MID function and then remerge cells with a concatenate function. This works but is messy and is only able to work on a fixed length string. I need to change many hundreds in 1 column of varying lengths strings. Anybody have any ideas????