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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dr. Darrell - 07 Dec 2005 21:43 GMT

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

Reply to this Message

Peo Sjoblom - 07 Dec 2005 21:55 GMT

=--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)

Signature

Regards,

Peo Sjoblom

> I have 52 worksheets which are titled "Week Ending 12-4-05" and so on.
>
[quoted text clipped - 4 lines]
>
> Darrell

Reply to this Message

Dr. Darrell - 08 Dec 2005 12:22 GMT

Thank you.

> =--MID(MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32),13,34)
>
[quoted text clipped - 11 lines]
> >
> > Darrell

Reply to this Message