Autofill columns from cell with multiple variables

mts2449

New Member
Joined
Jul 17, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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?
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,668
Office Version
  1. 365
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,148,280
Messages
5,745,829
Members
423,981
Latest member
ph1l

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top