Excel to show text before specific word or text in a cel.?
-
I would like Column B to show only the text BEFORE the word ‘DBA” Example 111111 DBA ONE RESULT 111111 2222 DBA TWO RESULT 2222 THREE DBA 33 RESULT THREE ABCDEFGHIGK DBA BLA RESULT ABCDEFGHIGK SHOW DBA NOT SHOW RESULT SHOW
-
Answer:
=LEFT(A1,SEARCH("DBA',A1)-2)
Jameel at Yahoo! Answers Visit the source
Other answers
try the following =LEFT(A1,SEARCH("DBA",A1,1)-2) it assumes there is always a space before DBA hope that helps
=SUBSTITUTE(A1, MID(A1, SEARCH("dba", A1)-1, 99), "") =REPLACE(A1, SEARCH(" DBA", A1), 9^9, "")
Related Q & A:
- How to read file from specific word in php?Best solution by Stack Overflow
- How do I search for text inside a PDF?Best solution by Stack Overflow
- How to append text to a JTextArea?Best solution by Stack Overflow
- How to curve text in Microsoft Word?Best solution by Ask Different
- How do you text from a computer to a Sprint phone?Best solution by eHow old
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.