I have data validation in one of my cells, right now it's a delimited list (meaning 4 digits followed by a comma and then a description, ex "1010, Whittelsey Wood Products").

but i need to tweak it some. Need to extract just the first four digits so that i can use that in a vlookup function in another cell.

is that possible?