<div>
Thanks Wizard, My info is in column F. &nbsp;Do I just replace the &quot;A&quot; in your example with F ?
</div>


Thanks Wizard, My info is in column F.  Do I just replace the "A" in your example with F ?

<div>
A2 is where the original string is so if your original string in F5 for example, then you would use F5 instead.<br />
<br />
Once you do first row, copy formula to rows below.
</div>


A2 is where the original string is so if your original string in F5 for example, then you would use F5 instead.

Once you do first row, copy formula to rows below.

<div>
I meant to give those points to &quot;Wizard.&quot; I am sorry, new at this.
</div>


I meant to give those points to "Wizard." I am sorry, new at this.

<div>
@Ashok did most of the work on this - seems unfair to give me all the credit
</div>


@Ashok did most of the work on this - seems unfair to give me all the credit

<div>
<div class="content wysiwyg-content">
I need to split information contained in one Excel column into two separate columns. &nbsp;The information is divided in the first column by the &quot;&nbsp; - &nbsp;&quot;. &nbsp;There is a space both before and after the hyphen. &nbsp;Content of cells include the case numbers and matter names of files.
</div>
</div>


I need to split information contained in one Excel column into two separate columns.  The information is divided in the first column by the "  -  ".  There is a space both before and after the hyphen.  Content of cells include the case numbers and matter names of files.

Need to split info in Excel column into two separate columns

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.