Help separating addresses text to column not working using delimited

Hello, I am completely new to excel and I've been trying to separate addresses by street address, city, state, and zip code. I was following a youtube tutorial where they used text to column and delimited in order to separate the text. I have been able to get to the part where you first select text to column and the option show up to select delimited and the addresses look fine on that page but once I click next all the addresses disappear and only the names are left and I have no idea what I'm doing wrong T.T