I only Want the Data from certain parts of the col. to be returned

  • Thread starter Thread starter P Johnson
  • Start date Start date
P

P Johnson

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.
 
try this
=MID(E1,FIND(":",E1)+1,FIND(" ",E1,FIND(" ",E1)+1)-FIND(":",E1))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
sumif 2
I want formula for multiple criteria using ih differnt column 2
index_match 5
Counting the # of values in a range ??? 8
INDEX return multiple columns 1
SumProduct with dates 4
Matching dates to cells 3

Back
Top