CODEWITHSUNDEEP
excel
JungleDiff
JungleDiff

Reputation: 3485

Excel Delimiting cells?

Say I have a cell that contains the data:

My Excel Data

How do I split/delimit this cell to have two separate cells: My Excel and Data

Basically, I want to delimit on the first space from the right.

Upvotes: 0

Views: 33

Answers (1)

Scott Craner
Scott Craner

Reputation: 152525

The first part:

=LEFT(A1,FIND("}}}",SUBSTITUTE(A1," ","}}}",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1)

Then using that to find the second part:

=TRIM(SUBSTITUTE(A1,B1,""))

enter image description here

Or reverse the order and find the last word first:

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",999)),999))

And for the first part:

=TRIM(SUBSTITUTE(A1,C1,""))

Upvotes: 1

Related Questions