Forum Discussion
Solved
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 sp...
Ms. LeBow
sorry for the on and off.
I think this time - its final.
pls see attached file.
hope this helps - finally.
thanks
Perfect! Thank you.
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..