I would like to extract some text in my WorkSheet Tab and enter it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 52 worksheets which are titled "Week Ending 12-4-05" and so on.

I would like to extract the date (text) and enter it as a date (number) in a
cell.

Is there a function or some code that can be entered to do this?

Darrell
 
=--MID(MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32),13,34)

format as date, if you only want a text representation of the date

=MID(MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32),13,34)
 
Thank you.

Peo Sjoblom said:
=--MID(MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32),13,34)

format as date, if you only want a text representation of the date

=MID(MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32),13,34)



--

Regards,

Peo Sjoblom

Dr. Darrell said:
I have 52 worksheets which are titled "Week Ending 12-4-05" and so on.

I would like to extract the date (text) and enter it as a date (number) in a
cell.

Is there a function or some code that can be entered to do this?

Darrell
Click to expand...
Click to expand...
 
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

Extract the 2 Lowest % 3
Extract Text 3
Excel display two dates in one cell - excel 2010 2
Source and Destination worksheet difference 5
Lookup in multple worksheets 5
Extraction 12
Unexplainable results from my vlookup 10
extract characters from filename 7

Back
Top