extract text string using formula excel 2007

Hi Expert's

I have the following text which I need to split as follows:

A1 = progress - pack out
b1 = pack out

and
a2 = progress - concerted
b2 = concerted
route217Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try

=MID(A2,SEARCH("-",A2)+2,LEN(A2))

Open in new window

Regards
0
 
Saqib Husain, SyedEngineerCommented:
Can you reword the question. I am not clear on what is given and what is required.
0
 
route217Author Commented:
Excellent. ...rgonxo1971
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.