Recent content by gerenrich

Thanks for that, and yes I can explain in more detail. I have a list of FLOCs (items) that in this case are laid out as follows: the mask is not consistent, but there is always a - (hyphen) between each section of the field which is being searched to see if it exists. 1st section being plant...

I have data that I am allowing user to drill down into one section at a time and using data validation "Indirect" statements referring to the previous cells. The supporting data is quiet large and I am looking for a way to automate the "named ranges" based on a column that i generate next to...

Actually this is perfect as it allows me to link to another table that is provided to me that contains definitions of the codes and the codes are listed as text, so all-in-all just perfect. again, can't thank you enough. Awesome work

You are awesome, used the function as-is and it gives just what I'm after. Can't express in words how grateful I am to you for this help.:D

Awesome, Sorry had to get a bite to eat, let me check this out and see if i have any other questions....:p thanks so much for all this input I will get back with a response as soon as I can

let me take a look and see. thanks

sorry, i must not have included one of those. here is one example of one. One key i did notice thru all records, there is always an alpha character before the 3 numerical digits which are needed, just a note A59252-1 again in this example, 592 being the desired numbers thanks

It can start anywhere from pos 2 thru about 8 there are almost 60k records, so possibly after pos 8, but i didnt see any after that point, don't think that will matter so much, maybe. and thank you for the welcome

I am trying to extract the first instance of 3 numbers from a string using an update query to update another field in the same table(Master Equipment) titled "Code". the field is called "Equipment". the strings vary in length as well as the location of the 3 numbers needed, but I have...