Posted to microsoft.public.excel.misc

external usenet poster

Posts: 5

Format of Postcodes

I have a formula, but it does not quite meet with my needs.

=REPLACE(A1,LEN(A1)-2,0,REPT(" ",8-LEN(A1)))

gives the result:

Eg:
AB19PQ
PE548YT

Changes it to:
AB1 9PQ
PE54 8YT

The 7-digit postcode is spaced correctly, but I would like an extra
space to appear in the 6-digit postcode i.e. AB 1 9PQ

Any ideas?

Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format of postcodes	pseudonym	Excel Discussion (Misc queries)	3	May 18th 07 11:40 AM
Postcodes starting with 0	fordrules01	Excel Discussion (Misc queries)	4	November 29th 06 08:32 AM
Standardising Postcodes	dewheatley	Excel Discussion (Misc queries)	19	November 8th 06 11:11 PM
Sorting UK Postcodes	Aristobulus	Excel Worksheet Functions	4	September 16th 06 04:51 PM
Postcodes	PH NEWS	Excel Worksheet Functions	6	May 5th 06 10:11 AM

All times are GMT +1. The time now is 05:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us