I have data that was originally in three columns, that was then combined usins a concatenate formula. I used an additional formula to then remove all duplicates from that data, now I want to use another formula to seperate the data back into the three columns. I don't want to use "text to columns" because I want it to update as the data is updated.
Here's how the data looks;
DAVID BARTON`MIKES LOADING SERVICE, INC`242342
I would like "Dave Barton", "Mikes Loading Service, Inc" in their own columns...(I don't actually need the last string of characters at this point.
I'm having no problems getting the first string of characters using the following formula:
=LEFT(J2,FIND("`",J2,1)-1)
But, I'm stumped on the "mid"
Best regards,
Bookmarks