Hi Noorain,

 

Thanks for a quick response but it does not work if town name have 2-3
spaces.... I need formula which can give text from second space of right
side.. it will always work

 

Thanks,

Jaideep

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince
Sent: Thursday, January 10, 2013 8:56 AM
To: excel-macros@googlegroups.com
Cc: noorain.ans...@gmail.com
Subject: Re: $$Excel-Macros$$ Extracting Zip Code from Address

 

Hi Noorain

 

In case of MAIDSTONE Wells ME14 4EA formula is not working 

 

regards

prince

On Thursday, January 10, 2013 8:47:59 AM UTC+5:30, NOORAIN ANSARI wrote:


Dear jaideep,

Pls use 
=right(A1,len(A1)-find(" ",A1))



Sent from BlackBerryR on Airtel

  _____  

From: "Jaideep Panchal" <jai....@gmail.com <javascript:> > 

Sender: excel-...@googlegroups.com <javascript:>  

Date: Thu, 10 Jan 2013 00:58:58 +0530

To: <excel-...@googlegroups.com <javascript:> >

ReplyTo: excel-...@googlegroups.com <javascript:>  

Cc: <jai_...@msn.com <javascript:> >

Subject: $$Excel-Macros$$ Extracting Zip Code from Address

 

Hi group,

 

 

I need some help in extracting zip code from address and hope u all will
provide a good help as always...

 

I need some formula to extract text after second last space because town
name might have 2-3 words..

 


Town & Zip Code

Result Required


LINCOLN LN4 4SY

LN4 4SY


LINCOLN LN6 3TA

LN6 3TA


MAIDSTONE Wells ME14 4EA

ME14 4EA


LEEDS LS3 1LY

LS3 1LY


PORTSMOUTH PO3 5RT

PO3 5RT


READING RG7 4AQ

RG7 4AQ


BLACKWOOD NP12 1ED

NP12 1ED


PERSHORE WR10 2JH

WR10 2JH


FLEETWOOD Wells FY7 8LG

FY7 8LG


TUNBRIDGE WELLS TN2 3EF

TN2 3EF


TEWKESBURY GL20 8LZ

GL20 8LZ

 

Thanks a lot in advance.

 

Jaideep Panchal

 

-- 
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-...@googlegroups.com
<javascript:> .
To unsubscribe from this group, send email to
excel-macros...@googlegroups.com <javascript:> .
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 

-- 
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.


Reply via email to