Sep 06 2018 06:57 PM
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.
Sep 06 2018 07:50 PM
Sep 06 2018 09:44 PM
Hi Cindy
You could try Flash Fill.
Sep 06 2018 10:16 PM
SolutionMs. LeBow
sorry for the on and off.
I think this time - its final.
pls see attached file.
hope this helps - finally.
thanks
Sep 07 2018 12:35 PM
Sep 07 2018 03:54 PM
Ms. LeBow
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.
thanks..
Sep 06 2018 10:16 PM
SolutionMs. LeBow
sorry for the on and off.
I think this time - its final.
pls see attached file.
hope this helps - finally.
thanks