Boards
EXCELP!!!!excel help
Hi
so what would this formula be?
I have a column B which contains 6 digit numbers
I've inserted a column A
now IF column B contains any of the following numbers:
56438
97564
21358
I want column A to read "202"
HELP