Search results

Thanks Doug, but I can write such a function myself. The problem is that when I point my Excel pivot table to my Access database as an External Data Source, then the function that I write is not picked up by Excel and I get an error message (see original post). I guess I need to be able to do...

Unfortunately not that easy; it could be anywhere; beginning, end after 1 space, after 100 spaces. It will always be exactly 7 characters, as alluded to by the regular expression. Thanks though.

I have a table with a text field (named Description), which may or may not contain an "ID Number", which is of the form [CHSV]#[A-Z][A-Z][A-Z]## - NB this is not necessarily at the beginning or the end, and will vary between records. For e.g. "something C4CLE01" "something H5STT02 Something...