how to extract a specific alpha numeric pattern from a string

[Nitin Upadhyay]

Hi,

I am working excel 2007 and I have 14k line items downloaded from erp in excel. I want to extract a specific alpha numeric pattern from every cell in a column.

for eg
A B
1 laptop PO#123243 PO#123243
2 Printer PO43223 PO43223

Column A is my source of data and I want to extract the PO numbers in column B.

Please help

Nitin

 

[Nitin Upadhyay]

Dear Jany,

I am not so expert with VBA script. It would be really helpful if you could give me code for this.

Thanks in advance,

Nitin.

 

[Madxgraphics]

you can write the VBA script to search and parse substrings - it is quite easy

That answer was quite helpful..Good going, now everybody knows what to do.....

 

[Nitin Upadhyay]

where is the answer?

 

[Nobody in particular]

where is the answer?

Sarcasm me thinks