Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

Need to split info in Excel column into two separate columns

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.
0
CynSzcz
Asked:
CynSzcz
  • 3
  • 2
  • 2
2 Solutions
 
AshokCommented:
"Jeff - Smith"      

=LEFT(A2, SEARCH("-",A2,1)-1)       

=RIGHT(A2,LEN(A2)-SEARCH("-",A2,1)-1)
0
 
CynSzczAuthor Commented:
Thanks Wizard, My info is in column F.  Do I just replace the "A" in your example with F ?
0
 
KCTSCommented:
Yes! - and copy the formula down as required
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
AshokCommented:
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.
0
 
CynSzczAuthor Commented:
Yay!! It worked.
0
 
CynSzczAuthor Commented:
I meant to give those points to "Wizard." I am sorry, new at this.
0
 
KCTSCommented:
@Ashok did most of the work on this - seems unfair to give me all the credit
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now