Hi Experts,
I have Consolidate Addresses along with PIN code in one column I need only the PIN the pin code in Next column Please confirm if any formula for this, Regards Appointment Address PIN Code 13/1, NS road, room no735, Martial street,kolkata-700001 Opp.Bank of India.Shanti Park,Mira Road East flat no 13,ground floor,guru nanak market,infrt of national park,laajpat nagar,part 4,delhi 110024 97-A, pocket-B, mayur vihar, phase-II, delhi-110092 A-7, SIDDHI APARTMENT OPP.AMAR~APARTMENT OPERA SOCI., nava vikas road, PALDI ahm 380007 # 27/161, Pragatinagar~Naranpura ahm 380013 jp nagar 6 th phase near sindoora kalyana mantap sarakki signal Bangalore-560078 THE FOYER HOUSE NO.52, 2ND CRSS HUCCHINS RD , COX TOWN, BANGALORE #229, 9th A Main~vijayanagar, NEAR GOVT SCHOOL, BANGALORE-40 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel