I have 400 names and addresses in column A and in rows 1-400. I need to
separate the name and address to create mailing labels in different columns.

Ex:

FirstName LastName Street City State Zipcode

I used Data, text-to-columns for the first row, but I would like to do that
for the other rows without have to do each row individually.

Is there any way to copy the format or anything else?