Solved

Need to split info in Excel column into two separate columns

Posted on 2013-12-29
8
343 Views
Last Modified: 2013-12-30
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
Comment
Question by:CynSzcz
  • 3
  • 2
  • 2
8 Comments
 
LVL 13

Accepted Solution

by:
Ashok earned 450 total points
ID: 39745451
"Jeff - Smith"      

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

=RIGHT(A2,LEN(A2)-SEARCH("-",A2,1)-1)
0
 

Author Comment

by:CynSzcz
ID: 39745462
Thanks Wizard, My info is in column F.  Do I just replace the "A" in your example with F ?
0
 
LVL 70

Assisted Solution

by:KCTS
KCTS earned 50 total points
ID: 39745468
Yes! - and copy the formula down as required
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 13

Expert Comment

by:Ashok
ID: 39745477
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
 

Author Comment

by:CynSzcz
ID: 39745483
Yay!! It worked.
0
 

Author Comment

by:CynSzcz
ID: 39745488
I meant to give those points to "Wizard." I am sorry, new at this.
0
 
LVL 70

Expert Comment

by:KCTS
ID: 39745489
@Ashok did most of the work on this - seems unfair to give me all the credit
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question