<div>
Thanks Barry, I am going to try this. &nbsp;I will let you know. &nbsp;Yes, the column with the codes will always be the same.
</div>


Thanks Barry, I am going to try this.  I will let you know.  Yes, the column with the codes will always be the same.

<div>
Barry!!! It works. &nbsp;One thing though. &nbsp;The sheet may have two or two hundred rows so the &quot;B2&quot; reference will not produce results for the entire sheet. &nbsp;How do I solve that?
</div>


Barry!!! It works.  One thing though.  The sheet may have two or two hundred rows so the "B2" reference will not produce results for the entire sheet.  How do I solve that?

<div>
<div class="content wysiwyg-content">
The following line (below) appears in an Excel spreadsheet. &nbsp;I need to copy the codes (A code and L code) from this column and place them into separate columns within the same sheet. &nbsp;I am exporting from a billing program and then need the codes in their own columns in order to import into another program.<br />
<br />
&quot;A106 Communicate (with client) L330 Depositions&quot;<br />
<br />
<br />
Example:<br />
<br />
&quot;A106&quot;...in one column and &quot;L330&quot; in another column within my sheet. &nbsp;Can leave the original column that contains text and codes in the sheet. &nbsp;Is there a formula that would do this for me.
</div>
</div>


The following line (below) appears in an Excel spreadsheet.  I need to copy the codes (A code and L code) from this column and place them into separate columns within the same sheet.  I am exporting from a billing program and then need the codes in their own columns in order to import into another program.

"A106 Communicate (with client) L330 Depositions"


Example:

"A106"...in one column and "L330" in another column within my sheet.  Can leave the original column that contains text and codes in the sheet.  Is there a formula that would do this for me.

Need formula to separate data from column and send to another

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

Office Productivity

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.

Office Suites-Other

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.