Autofill columns from cell with multiple variables

[mts2449]

I am working on a worksheet that I can use to import employee information from one program to another easily. I have generated a report that currently is displaying each employees information in one cell. I have created columns for the employees first name, last name, SSN, phone number, street address, city, state, zip, wage rate, and deductions. When I use auto fill in the column it only copies the header. How can I separate the information from the first cell in each row across multiple columns?

 

[alansidman]

Depending on how your data is stored in the one column, you may use Text to Columns or Power Query or you may need a VBA solution. Without further information, it is difficult to offer you a working solution. If you would like to share some sample data (anonymized for confidentiality), we can then offer up a better answer. When posting your data, use the XL2BB function on this site so that we don't have to retype your data.