Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
flow23
 
Posts: n/a
Default postcode

I am working with UK postcodes and need to strip out the area and district
automatically

The post code comes in following

A1 2BC
D34 5EF
GH6 7IJ
KL8M 9NQ


The part before the space contains the area and district.

The first is area which can be a single letter or double letter. The second
bit is usually a single number, however in london it can be a number and
letter.


So the results would be as follows.

A
D
GH
KL

How can I extract this automatically?

Many thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
UK Postcode formula KeLee Excel Worksheet Functions 2 November 1st 05 01:16 PM
Converting postcode to sales area LarsF Excel Discussion (Misc queries) 2 August 18th 05 10:12 AM
PING: JulieD & AlfD re Sorting By Postcode Steve Excel Discussion (Misc queries) 1 March 22nd 05 10:41 PM
Sorting by PostCode Steve Excel Discussion (Misc queries) 6 March 22nd 05 12:50 PM
HELP WITH POSTCODE FORMATTING UK EXCEL MAN Excel Worksheet Functions 1 December 27th 04 09:01 AM


All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"