| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling Year from a text string
For the year:
=LEFT(A1,2) For the month: =MID(A1,3,2) HTH, Elkar "Rod Cooley" wrote: I'm trying to pull a 2 digit year from a text sting. This is how it looks. I'm trying to extract the 2 digits from the left for the year, then the next 2 digits for the month. Is there a way of doing this? 960158963415 011158694632 001056956225 040138693254 Thanks -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling text from a cell | Excel Worksheet Functions | |||
| help wanted for pulling text data | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| pulling text into a sum formula | Excel Worksheet Functions | |||
| pulling characters out of a string | Excel Worksheet Functions | |||
Linear Mode
