Hi!

I tried to search previous posts for this, but honestly couldn't figure what search terms to use ...

My payroll system spits out a file each day that has a horrendous format .... lots of merged cells and such. I'm trying to build code that prepares this data file for use in a tracking template, the first step of which is to parse the co-worker key (name & employee #). And, it's this first step that has me stuck.

The data (co-worker name & #) starts in J19, with 53 rows btw each subsequent entry. The format for this entry is John Doe (12345678). The number should be 8 digits but isn't always; it *is* always between the ( ).

Can you help me with coding to isolate just the employee # and put in the cell next to the original ... and do this until the next cell (53 rows below) is blank?

Thanks in advance!

Ray