Split Combined Names, IDs, and Appointment Times into Excel Columns
Question details
Separate combined records into columns for Social Security numbers, names, and appointment times.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A source program exports records into one column with inconsistent spacing between fields.
- Observed behavior
- Social Security numbers, names, and appointment times appear together in each source cell rather than in separate columns.
Check a few records for spaces, @ symbols, and names containing multiple words. Make sure there are enough empty columns beside the source data for the split results, and handle Social Security numbers according to your organization's privacy rules.
Use Text to Columns to split records by delimiters
Use this method when spaces and @ symbols consistently separate the parts of each record.
Select the cells containing the combined records in column A.
Go to Data > Text to Columns, select Delimited, and click Next.
Select Space, then select Other and enter @. If extra spaces create empty fields, select Treat consecutive delimiters as one and check the preview.
Click Next and review each previewed column. Select Do not import column (skip) for unwanted fields, and set the Social Security number column to Text to preserve leading zeros.
Set Destination to an empty cell beside the first source record, such as $B$2, and click Finish. Check several rows to confirm that names and times are in the intended columns.

Use Flash Fill to extract each field from examples
Use Flash Fill when the spacing varies and delimiter-based splitting does not produce consistent columns.
Separate Combined Records with WPS Spreadsheets
Open your workbook in WPS Spreadsheets and use Text to Columns to separate records by spaces and @ symbols. Review the preview and results for multiword names and inconsistent spacing.
- 1. Open the workbook: Open the Excel file in WPS Spreadsheets and select the cells containing the combined records.
- 2. Start the split: Choose Data > Text to Columns and select the delimited option.
- 3. Set delimiters: Select Space and enter @ as an additional delimiter. Review the preview for extra columns or split names.
- 4. Apply and check: Set the ID column to Text, choose an empty destination beside the source data, and finish the split. Check several rows against the originals.

Frequently Asked Questions
How do I prevent leading zeros from disappearing from Social Security numbers?
In Excel's Text to Columns wizard, select the Social Security number column in the preview and choose Text before clicking Finish.
What if extra spaces create blank columns?
In Data > Text to Columns, choose Delimited and select Treat consecutive delimiters as one. Check the preview before continuing.
Why is a full name split across several columns?
When Space is a delimiter, Excel splits at spaces within names too. Use Flash Fill with example names or combine the affected parts manually, then check the results.
Can I keep the original combined records?
Yes. In the Text to Columns wizard, set Destination to an empty cell beside the source data, such as $B$2, instead of the original column.




