Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I would like to extract some text in my WorkSheet Tab and enter it
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I would like to extract some text in my WorkSheet Tab and enter it
=--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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I would like to extract some text in my WorkSheet Tab and ente
Thank you.
"Peo Sjoblom" wrote: =--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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|