I have a sheet with about 10,000 names and addresses in it in which the city
and state were entered into one cell. I have tried all day to find a
function or way to split them up. There are no commas in between and they
are not lined up to be able to use text to column. I need help, please?

Thank you.