short characters and digits in a cell

[sawanmeet]

[TABLE="width: 626"]
<tbody>[TR]
[TD="class: xl66, width: 626"]NAYASARAK, CUTTACK, DISTRICT CUTTACK, ORISSA-753002
[TABLE="width: 626"]
<tbody>[TR]
[TD="class: xl68, width: 626"]BAGHTHALA, BLOCK, TAHSIL - BAWAL, DISTRICT - REWARI, PIN - 123501, HARYANA
[TABLE="width: 626"]
<tbody>[TR]
[TD="class: xl68, width: 626"]947,10TH 'D' ROAD, SARDARPURA, JODHPUR - 342001
[TABLE="width: 626"]
<tbody>[TR]
[TD="class: xl68, width: 626"]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. [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[jarjarbingie]

[table="width: 626"]
<tbody>[tr]
[td="class: Xl66, width: 626"]nayasarak, cuttack, district cuttack, orissa-753002
[table="width: 626"]
<tbody>[tr]
[td="class: Xl68, width: 626"]baghthala, block, tahsil - bawal, district - rewari, pin - 123501, haryana
[table="width: 626"]
<tbody>[tr]
[td="class: Xl68, width: 626"]947,10th 'd' road, sardarpura, jodhpur - 342001
[table="width: 626"]
<tbody>[tr]
[td="class: Xl68, width: 626"]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.[/td]
[/tr]
</tbody>[/table]
[/td]
[/tr]
</tbody>[/table]
[/td]
[/tr]
</tbody>[/table]
[/td]
[/tr]
</tbody>[/table]

=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