<div>
It is worth noting that you'll get a runtime error if LN is not in the string when combining MID with InStr. To avoid this, use three statements:<br />
Text = &quot;&quot;<br />
i = InStr(1, Source, &quot;LN&quot;)<br />
If i &gt;&nbsp;0 Then &nbsp;Text = Mid(Source, i)<br />
<br />
The first statement (clearing the value of Text variable) is required if you are returning values from more than one cell. Without it, if the second (or later) cell doesn't contain LN, then Text would repeat its preceding value.
</div>


It is worth noting that you'll get a runtime error if LN is not in the string when combining MID with InStr. To avoid this, use three statements:
Text = ""
i = InStr(1, Source, "LN")
If i > 0 Then  Text = Mid(Source, i)

The first statement (clearing the value of Text variable) is required if you are returning values from more than one cell. Without it, if the second (or later) cell doesn't contain LN, then Text would repeat its preceding value.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I want search and get a string from a sentence.<br />
for example, the string contain the word &quot;LN_&quot; but LN_ is not in the begining of the string it can be like &quot;abc LN_defghijkelmopqrstuv&quot; &nbsp;or &quot;abcdefg LN_jkdjslajlkdjljflkjl&quot;<br />
I want to get the portion of the string start with LN_ up to the end of the string.<br />
from above two strings I want to get &quot;LN_defghijkelmopqrstuv&quot; and &quot;LN_jkdjslajlkdjljflkjl&quot;<br />
<br />
Please advise VBA code to do that.<br />
<br />
Thanks
</div>
</div>


Hi Experts,

I want search and get a string from a sentence.
for example, the string contain the word "LN_" but LN_ is not in the begining of the string it can be like "abc LN_defghijkelmopqrstuv"  or "abcdefg LN_jkdjslajlkdjljflkjl"
I want to get the portion of the string start with LN_ up to the end of the string.
from above two strings I want to get "LN_defghijkelmopqrstuv" and "LN_jkdjslajlkdjljflkjl"

Please advise VBA code to do that.

Thanks

search and get a string from a line

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.