Need a Macro to extract values from one column into different columns

Hi,

I need a macro to extract few values from a column (i.e) Please find the attached file. Here in the file whichever is within "par(xxxx)" and "bpar(xxxx)" must be copied and paste the values into the new columns based on occurrences. kindly please do help me out. Thanks in advance for your reply.

The key to success with this is the recursive use of InStr.
The function is called FindPar and the syntax is =FindPar (CellRef, "par(",Instance) where instance is 1, 2, 3 ... in other words the occurrence of par or bpar in the input string.

Please Login or Register  to view this content.