Once upon a time a management accountant (thankyou Amanda) showed me how to do this and I keep forgetting what it’s called so I figure I should blog it so I don’t forget and everyone else can add it to their bag of tricks …
1) Select the range of cells that contains the text values. The range can be any number of rows tall, but no more than one column wide.
Note: There must be one or more blank columns to the right of the selected column or the data to the right of the selected column will be overwritten.
2) On the Data menu, click Text to Columns.
Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into columns.
And that’s how you split the accounting flexfield by it’s delimiter when you’re in a hurry and can’t write a custom report 🙂
Have a great day!