Remove some data
Posted by Jack in UK on January 02, 2002 10:41 AM
Hi all, need help here, wonder if anyone can help
If B2:B??? = Mr Excel (564) or any number> 10000 if 10000+ = A0001 to A9999 i need to remove them all the bits in braces???
rouble is this can be any name Mr A BCDEF etx, ive millins of these to update daily as comes from ODBC download, need custon funtion really or formula or VBA to do just this , so leave name only as Mr A Excel ect
PS The braces is always afeter the name ie to the right if that helps