Data Import & Export

Split Combined Names, IDs, and Appointment Times into Excel Columns

Adam DavisAdam Davis Nov 18, 2026 869 views

Question details

Separate combined records into columns for Social Security numbers, names, and appointment times.

Split Combined Names, IDs, and Appointment Times into Excel Columns
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.
Before you start

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.

Solution 1Recommended

Use Text to Columns to split records by delimiters

Use this method when spaces and @ symbols consistently separate the parts of each record.

1
Select the source records

Select the cells containing the combined records in column A.

2
Open Text to Columns

Go to Data > Text to Columns, select Delimited, and click Next.

3
Choose the delimiters

Select Space, then select Other and enter @. If extra spaces create empty fields, select Treat consecutive delimiters as one and check the preview.

4
Set column formats

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.

5
Choose a destination

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 Text to Columns to split records by delimiters
Check multiword fields: A space delimiter can split multiword names or times into additional columns. If the preview does not align the fields consistently, use Flash Fill or review and combine the affected parts manually.
Split records in WPS Spreadsheets

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. 1. Open the workbook: Open the Excel file in WPS Spreadsheets and select the cells containing the combined records.
  2. 2. Start the split: Choose Data > Text to Columns and select the delimited option.
  3. 3. Set delimiters: Select Space and enter @ as an additional delimiter. Review the preview for extra columns or split names.
  4. 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.
Split combined IDs, names, and appointment times into columnsOpen and edit Microsoft Excel XLS and XLSX filesPreview delimiter-based splits before applying themUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.