I have a Company Code, 4 digits, and a Profit Center, 7 digits hyphenated.
Eg CC 5500, PC 5500-123
The CC’s 4 digits typically start the PC’s 7 digits, but not always. I created a formula to extract the PC’s first 4, [ =LEFT(C9,4) ] and then compared that to the CC, so that the ones that didn’t match would be flagged. But this didn’t even work on the first line, where the numbers were the same. I’m guessing this is a text to number issue? Please help.
I know the numbers didnt match btw b/c I evaluated the formula and the if condition eval'd as false.
Eg CC 5500, PC 5500-123
The CC’s 4 digits typically start the PC’s 7 digits, but not always. I created a formula to extract the PC’s first 4, [ =LEFT(C9,4) ] and then compared that to the CC, so that the ones that didn’t match would be flagged. But this didn’t even work on the first line, where the numbers were the same. I’m guessing this is a text to number issue? Please help.
I know the numbers didnt match btw b/c I evaluated the formula and the if condition eval'd as false.
