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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Hi,

Try:

=REPLACE(A1,FIND("@",SUBSTITUTE(A1,CHAR(10),"@",12)),FIND("@",SUBSTITUTE(A1,CHAR(10),"@",13))-FIND("@",SUBSTITUTE(A1,CHAR(10),"@",12)),"") :eek:
 
Upvote 0
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.
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,585
Messages
6,114,519
Members
448,575
Latest member
hycrow

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
Back
Top