Remove PostCode from Address field

**aedislee** · 08-20-2014, 09:44 AM

Hi all

I have a list of addresses, which are comma seperated, all ending with a PostCode

How Can i strip out the PostCode field please?

Thanks

**Ron Coderre** · 08-20-2014, 09:48 AM

Can you post some sample data so we'll know what you're working with?
(Make sure you replace any confidential data with dummy data)

**aedislee** · 08-20-2014, 09:50 AM

no problem

Examples as follows

123 high street, ZZ14, WPG
123 hight street, test town, nowhere, z1 4ut

**AlKey** · 08-20-2014, 09:53 AM

Try this one

=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255*2)),",","")

	A	B
1	123 high street, ZZ14, WPG	ZZ14 WPG
2	123 hight street, test town, nowhere, z1 4ut	z1 4ut

Re: Remove PostCode from Address field