| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve certain char within a string?
In cell A1, there is a string "Updated: 2007-06-29 15:45(3)"
If the string in cell A1 contains the key word "Updated", then retrieve the date "2007-06-29" in cell B1. Does anyone have any suggestions? Thank in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to retrieve certain char within a string?
Try this:
Assuming the date is *always* in this format: yyyy-mm-dd and that "Updated" (if present) is *always* at the beginning of the string: =IF(LEFT(A1,7)="Updated",DATEVALUE(MID(A1,10,10)), "") Format as DATE -- Biff Microsoft Excel MVP "Eric" wrote in message ... In cell A1, there is a string "Updated: 2007-06-29 15:45(3)" If the string in cell A1 contains the key word "Updated", then retrieve the date "2007-06-29" in cell B1. Does anyone have any suggestions? Thank in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to verify the first char of the string in excel? | Excel Discussion (Misc queries) | |||
| How to verify the first char of the string in excel? | Excel Discussion (Misc queries) | |||
| How to verify the first char of the string in excel? | Excel Discussion (Misc queries) | |||
| How do i get the last position of a char (space) in a string? | Excel Worksheet Functions | |||
| string/char CONTAINS function? | Excel Worksheet Functions | |||
Hybrid Mode
