Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

extract text string using formula excel 2007

Posted on 2014-01-08
3
Medium Priority
?
314 Views
Last Modified: 2014-01-08
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
0
Comment
Question by:route217
3 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39764852
Can you reword the question. I am not clear on what is given and what is required.
0
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 39764853
Hi,

pls try

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

Open in new window

Regards
0
 

Author Comment

by:route217
ID: 39764860
Excellent. ...rgonxo1971
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question