How to make a macro check for the first and third characters in a string
Posted by Kurt on September 02, 2000 6:16 PM
I HAVE A QUESTION IS THERE AWAY TO HAVE THIS CHECK FOR A MATCH OF CERTAIN LETTERS IN A WORD INSTEAD OF THE WHOLE WORD. EXAMPLE:COLUMN A: BAT,DOG
COLUMN B:BAG,FAT,CAT,CAP,DIG RESULT WOULD BE COLUMN C:BAG IF TESTING FOR FIRST TWO LETTERS OR FAT,CAT IF TESTING FOR LAST TWO LETTERS OR DIG IF TESTING FOR FIRST AND THIRD LETTERS.!!!
THANKS
Kurt