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: Extr...
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.