Forum Discussion
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.
Ms. LeBow
sorry for the on and off.
I think this time - its final.
pls see attached file.
hope this helps - finally.
thanks
5 Replies
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..
Hi Cindy
You could try Flash Fill.
- if you want to learn further - here is the site:
https://www.ablebits.com/office-addins-blog/2016/06/01/split-text-string-excel/
