Mid Function?

ply@lockton.com

Board Regular
Joined
Mar 25, 2003
Messages
125
I have the following value in a cell.



-----Original Task-----
Subject: Test Account1005

Status: Completed
% Complete: 100%
Date completed: Mon 3/8/2004

Total work: 0 hours
Actual work: 0 hours

Requested by: Ly, Phuong

These are my comments.
------------
This is your task.


I'm trying to crop everything out except for the comments. Any ideas? Please keep in mind that the person who requested this task could be different every time, so the length of the name isn't going to be consistent.
:unsure:

Thanks!
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

Try:

=REPLACE(A1,FIND("@",SUBSTITUTE(A1,CHAR(10),"@",12)),FIND("@",SUBSTITUTE(A1,CHAR(10),"@",13))-FIND("@",SUBSTITUTE(A1,CHAR(10),"@",12)),"") :eek:
 

elgringo56

Well-known Member
Joined
Apr 15, 2002
Messages
869
He may have the wrong forum, but his post is still better than most of the crap that has been showing up on here lately.
 

ply@lockton.com

Board Regular
Joined
Mar 25, 2003
Messages
125
Thanks Fairwinds. The code you provided didn't quite work, but it got me started on the path to the solution. I ended up using a combination of Mid and Find functions. (y)
 
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,152,322
Messages
5,769,448
Members
425,547
Latest member
Iano

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