Seperate Text from String

**krunk** · 09-25-2014, 10:08 AM

Hi,

I am trying to seperate a string of text but everything i've tried isn't work.

Here are a few examples of what type of text i need to seperate:

JanActual2014SP East - Duluth, GA MBI
JanActual2014JP - Little Rock, AR MBI
JanActual2014JP - Florence, AL Wallboard

Thanks,
Kali

**AlKey** · 09-25-2014, 10:12 AM

It is not all clear of what exactly needs to be separated.
Could you please show an example and desired outcome?

**Fotis1991** · 09-25-2014, 10:14 AM

So for your first example the expected result is??:

JanActualSP East - Duluth, GA MBI

**krunk** · 09-25-2014, 10:19 AM

Here is what I'd like it to look like in excel:

And really if i could figure out a formula to just caputure EVERYTHING after 2014 i can use Mid and Left funcitons to get the first three but i can't figure out how to capture everything after the year 2014. Does this make sense?

Column A Column B Column C Column D
Jan Actual 2014 JP - Hornlake, MS
Jan Actual 2014 SP - East Duluth, GA MBI
Jan Actual 2014 JP - Little Rock, AR MBI

**AlKey** · 09-25-2014, 10:37 AM

Maybe like this

in B1 and copy down

=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ","|",1),"|- ","|"),"|",REPT(" ",255)),255))

	A	B
1	JanActual2014SP East - Duluth, GA MBI	East - Duluth, GA MBI
2	JanActual2014JP - Little Rock, AR MBI	Little Rock, AR MBI
3	JanActual2014JP - Florence, AL Wallboard	Florence, AL Wallboard