Auto-formatting a text string.

[Steve-B]

Hi all,

I have a cell containing a post code (U.K). For example CF678JU however I need it to be formatted to show CF67 8JU. Is there a quick option of setting a formatting rule to add the space instead of me going into each cell and changing... (there's thousands of them!!!)

Thanks in advance...

[sweep]

Hi,

I don't think there's a formatting option to do this, but you can use a formula to convert them

=LEFT(A1,LEN(A1)-3)&" "&RIGHT(A1,3)

will add a space in the appropriate place to the postcode in A1

[Steve-B]

Diolch yn fawr iawn....

I'm originally from Maesteg!!!!