robert0803
Board Regular
- Joined
- Aug 3, 2005
- Messages
- 115
I have column A that has route numbers ( 276, 200, B01) some alpha and numeric. I have column with the courier names (Courier 1, Courier 2..etc).
I need a formula that will add the courier names in column B by using the first character of the route number to determine the courier used.
Example: All routes beginning with 2 should be Courier 1
All routes beginning with B should be Courier 2.
Please help!
I need a formula that will add the courier names in column B by using the first character of the route number to determine the courier used.
Example: All routes beginning with 2 should be Courier 1
All routes beginning with B should be Courier 2.
Please help!