short characters and digits in a cell

[sawanmeet]

NAYASARAK, CUTTACK, DISTRICT CUTTACK, ORISSA-753002 BAGHTHALA, BLOCK, TAHSIL - BAWAL, DISTRICT - REWARI, PIN - 123501, HARYANA 947,10TH 'D' ROAD, SARDARPURA, JODHPUR - 342001 PIN 123504, NOORGARH CHOWK, HAILY MANDI, PALHAWAS ROAD, NOORGARH, i have a excel file having address in its D cell wants to extract pin numbers from it need to separate 6 digit pin codes in a separate cell for each entry in other column. <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

 

[jarjarbingie]

nayasarak, cuttack, district cuttack, orissa-753002 baghthala, block, tahsil - bawal, district - rewari, pin - 123501, haryana 947,10th 'd' road, sardarpura, jodhpur - 342001 pin 123504, noorgarh chowk, haily mandi, palhawas road, noorgarh, i have a excel file having address in its d cell wants to extract pin numbers from it need to separate 6 digit pin codes in a separate cell for each entry in other column. <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

=mid(d2,search("//////",substitute(substitute(substitute(substitute(substitute(substitute(substitute(substitute(substitute(substitute(d2,0,"/"),1,"/"),2,"/"),3,"/"),4,"/"),5,"/"),6,"/"),7,"/"),8,"/"),9,"/")),6)

 

[taurean]

Since you are looking at Indian Pin Codes, following approach shall work as well:
=AGGREGATE(14,6,MID(D2,ROW($A$1:INDEX($A:$A,LEN(D2)-5)),6)+0,1)
* AGGREGATE function Requires Excel 2010 or higher