29079446.xlsx

<div>
Are the key words always followed by a semi-colon?
</div>


Are the key words always followed by a semi-colon?

EE29079446.xlsm

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have content as mentioned below in a cell in EXCEL sheet. I wanted to split the content based on keywords &quot;NAME&quot;, &quot;EMPLOYER&quot; and &quot;DESIGNATION&quot; into three different columns.<br />
<br />
NAME: LOUIS GOERGE EMPLOYER: WALMART DESGINATION: MARKETING MANAGER.<br />
<br />
Please let me know if this can be done using VB script or macro and help me with logic.<br />
<br />
Thanks.
</div>
</div>


Hello,

I have content as mentioned below in a cell in EXCEL sheet. I wanted to split the content based on keywords "NAME", "EMPLOYER" and "DESIGNATION" into three different columns.

NAME: LOUIS GOERGE EMPLOYER: WALMART DESGINATION: MARKETING MANAGER.

Please let me know if this can be done using VB script or macro and help me with logic.

Thanks.

Split content in a cell based on key word

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

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 Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.

Microsoft Word

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.