Split Data

raghukrishnareddy

New Member
Joined
Aug 26, 2009
Messages
44
Can some one please help......!

I have data in one cell which is shown below

------- Activity Log - 2010-07-27 13:20:29 -------<br /><br />!~1.2010-07-27~!Raghavendra K - created Change Order<br />!~2.2010-07-27.1~!Raghavendra K - set Status: CCF Filed<br />Raghavendra K - set Response Date: 2010-07-30<br />Raghavendra K - set Type: Sizing and Scheduling<br />Raghavendra K - set Revenue: Chargeable and Funded<br />Raghavendra K - set Product: Activator<br />Raghavendra K - added Primary PMO: Joel Gosselin<br />Raghavendra K - added Notification: Chris Ullock<br />Raghavendra K - added Notification: David Fowler<br />Raghavendra K - added Notification: Mohammed Zia<br />Raghavendra K - added Notification: Yan Faubert<br />Raghavendra K - added Originating Customer: Bell Canada (IPVPN)<br /><br />


i need the above data in diffrent cells as shown below

------- Activity Log - 2010-06-28 14:52:54 -------

Raghavendra K - created Change Order
Raghavendra K - set Status: CCF Filed
Raghavendra K - set Response Date: 2010-07-02
Raghavendra K - set Type: Sizing and Scheduling
Raghavendra K - set Revenue: Chargeable and Funded
Raghavendra K - set Product: Activator
Raghavendra K - added Primary PMO: Ravi Mittal
Raghavendra K - added Originating Customer: Swisscom AG
 
Last edited:

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,425
Office Version
  1. 2019
I may have misunderstood your query so this may not work

Try (untested)

Helper column

in B1
=RIGHT(A1,LEN(A1)-FIND("Raghavendra",A1))

in C1
=IF(ISERROR(FIND("notified",B1)),B1,"")

Copy / Paste Special / Paste Values back into column C

Sort column C ascending
delete all blank rows as they contain "added notified" and you dont want them
 

Sandeep Warrier

Well-known Member
Joined
Oct 31, 2008
Messages
2,672
Hi,

The split data would be the name in one column and activity in one column. Am I right?

#VALUE!
Excel 2003
Cell Formulas
RangeFormula
B1=IF(ISNUMBER(FIND("!",A1)),MID(A1,FIND("!",A1,2)+1,FIND(" - ",A1,FIND("!",A1,2))-FIND("!",A1,2)-1),LEFT(A1,FIND(" - ",A1)-1))
C1=MID(A1,FIND(" - ",A1,FIND(B1,A1))+3,LEN(A1))
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,693
Messages
5,833,142
Members
430,196
Latest member
rez5656

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top