I have a spreadsheet that was given to me and it include zip code ranges with only the first 3 digits. so in a column A1 004-005 and in column B1 it will have 2 or 3 or something like that. Column A2 it might be 006-063 and B2 might be 3, while column A3 might be 008. So what I am looking for is a way to break out the ranges into single rows so it would take A1 004-005 and then it would be A1 004 and A2 005 keeping the value of B1. Is there a way to do that? Right now my only option is to do it by hand and that could take a few hours to do.