Solved

Need help with splitting data in excel

Posted on 2014-01-21
2
269 Views
Last Modified: 2014-01-21
I have attached a sample excel file where I need to split data from one cell to two other cells.

I have added explaination on what I need. Can someone help me with the formula in the file and attach here again?
Sample-for-data-split.xlsx
0
Comment
Question by:Gerhardpet
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39797286
Try in B2:

=IF(ISNUMBER(SEARCH("<ul>",A2)),MID(A2,FIND("<br /",A2),3000),A2)

and in C2:

=SUBSTITUTE(A2,B2,"")

both copied down
0
 
LVL 1

Author Closing Comment

by:Gerhardpet
ID: 39797449
Perfect...just what I wanted. Thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now