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.
View best response
You could try Flash Fill.
sorry for the on and off.
I think this time - its final.
pls see attached file.
hope this helps - finally.
welcome. Glad to help.
The Date and the Amount is quite easy (I searched the net - as I always do), the middle portion stymied me a bit so I had to get help from somewhere and Mr. Rothstein was very helpful with that.
The amount column was formatted but it may not be what you need - you can use the column next to it and multiply all amount cells by 1 to get the characteristics of a numeral then hide the D column.