Sorry to be a pain, as i already posted today. But as i knew the other formulas, thought it would be ok. Thought i could use 3 different formulas in the one cell. I need to pick up ONLY the first digit. Every formula ive tried from google to use multiple numbers etc just isnt working.
Any code in the cell that starts with a 4 or 6 needs to read RAIL, the rest to read ROAD. I can only pick up the number 4, not the number 6.

Current formula =IF(B2="","",IF(LEFT(B2)="4","RAIL","ROAD"))