I'm trying to have data in cell A3 supply formatting to cell D3 if a true value is returned.
BUT cell A3's data has 13 characters I need the first 9 characters only to be read.
For example it could read C21167854-002
I need to ignore the 002 as those numbers are prone to change but the C21167854 is relatively constant.
BUT cell A3's data has 13 characters I need the first 9 characters only to be read.
For example it could read C21167854-002
I need to ignore the 002 as those numbers are prone to change but the C21167854 is relatively constant.