How to split string into 3 columns, using first space and last space characters found.

[Cindy LeBow]

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.

[#2]

if you want to learn further - here is the site:
https://www.ablebits.com/office-addins-blog/2016/06/01/split-text-string-excel/

[#3]

Hi Cindy

You could try Flash Fill.

[#4 · Accepted solution]

Ms. LeBow

sorry for the on and off.

I think this time - its final.

pls see attached file.

hope this helps - finally.

thanks

[#5]

Perfect! Thank you.

[#6]

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..