Forum Discussion

Cindy LeBow's avatar
Cindy LeBow
Copper Contributor
Sep 07, 2018
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...
split
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Sep 07, 2018

    Ms. LeBow

    sorry for the on and off.

    I think this time - its final.

    pls see attached file.

    hope this helps - finally.

    thanks

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Sep 07, 2018
if you want to learn further - here is the site:
https://www.ablebits.com/office-addins-blog/2016/06/01/split-text-string-excel/

Resources