I have a list of data with the company names, but I get twice the names and some additional strings that I do not need:
I only want to remain the company names, for example:
How do I do this in excel?
2 Answers
If your data is always like company name (~US$) (#T) company name you could do:
=TRIM(LEFT(A1;FIND("(";A1)-1))
It works like this:
The string that I want to extract is always before the first (~U$).
Then this will work for you.
To pull the string between the first instnace of (#T) and the second instance of U$ try...
=MID(A1,SEARCH("(#T)",A1)+7,LEN(A1)-SEARCH("U$)",A1,SEARCH("U$",A1))-1)
This solution extracts the middle string and is result of me misreading the question, although it still does work
Related