Thread
:
I only Want the Data from certain parts of the col. to be returned
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
I only Want the Data from certain parts of the col. to be returned
try this
=MID(E1,FIND(":",E1)+1,FIND(" ",E1,FIND(" ",E1)+1)-FIND(":",E1))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"P Johnson" <P
wrote in message
...
I know this is a basic function, but I can't remember how to do it.
Col A Col B
Job: 08-098 started 1/2008
In col A I only want the 08-098 to be listed from Col B.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett