split
1 Topic
How to split string into 3 columns, using first space and last space characters found.
I have a list of transactions like so: 12/05 DESCRIPTION OF TRANSACTION HERE 12345678 25.00 I need to split them up into separate columns using the first space after the date, and the last space before the amount, like this: DATE | DESCRIPTION | AMOUNT Help is much appreciated.Solved2KViews0likes5Comments