Forum Discussion
Split a fixed format column cell into 3 separate columns
My financial download has account ID as 1 10 digit field: Example: 1234-11-22
I want to know if there is a way to divide that account ID into 3 separate field segments based on fixed format:
Extract 1234 into separate field; 11 into separate field; and 22 into separate field. I want to sort and do subtotals on each of the 3 segments for reporting financial data.
1 Reply
I assume that these IDs are in a column.
Make sure that there are two empty columns to the right of it.
Select the IDs.
On the Data tab of the ribbon, click Text to Columns.
In Step 1 of the resulting dialog, select Delimited, then click Next.
In Step 2, click in the box next to Other and type a hyphen -. This will automatically tick the Other check box.
Click Finish.
