| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a text string into a date?
I am downloading a .CSV file which includes date info, stored as text (form
is: yyyymmdd120000[0:GMT]), and I want to convert it to a date recognized by Excel. P.S. I don't mind chopping off the '120000[0:GMT]' string by using the REPLACE command, but converting the remaining yyyymmdd string has got me stumped! Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I convert a text string into a date?
With your date string in a1.
=DATE(VALUE(LEFT(A1,4)),VALUE(MID(A1,5,2)),VALUE(R IGHT(A1,2))) "JJMCDD02" wrote in message ... I am downloading a .CSV file which includes date info, stored as text (form is: yyyymmdd120000[0:GMT]), and I want to convert it to a date recognized by Excel. P.S. I don't mind chopping off the '120000[0:GMT]' string by using the REPLACE command, but converting the remaining yyyymmdd string has got me stumped! Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I convert a text string into a date?
Try using the DATE FUNCTION with LEFT,MID,RIGHT.
"JJMCDD02" wrote in message ... I am downloading a .CSV file which includes date info, stored as text (form is: yyyymmdd120000[0:GMT]), and I want to convert it to a date recognized by Excel. P.S. I don't mind chopping off the '120000[0:GMT]' string by using the REPLACE command, but converting the remaining yyyymmdd string has got me stumped! Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I convert a text string into a date?
try:
=DATE(--LEFT(A1,4),--MID(A1,5,2),--MID(A1,7,2)) -- Gary''s Student "JJMCDD02" wrote: I am downloading a .CSV file which includes date info, stored as text (form is: yyyymmdd120000[0:GMT]), and I want to convert it to a date recognized by Excel. P.S. I don't mind chopping off the '120000[0:GMT]' string by using the REPLACE command, but converting the remaining yyyymmdd string has got me stumped! Thanks. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I convert a text string into a date?
Thank you Carlos, Barb and Gary''s Student. Your solution worked and you
will save me a lot of time! "Barb Reinhardt" wrote: Try using the DATE FUNCTION with LEFT,MID,RIGHT. "JJMCDD02" wrote in message ... I am downloading a .CSV file which includes date info, stored as text (form is: yyyymmdd120000[0:GMT]), and I want to convert it to a date recognized by Excel. P.S. I don't mind chopping off the '120000[0:GMT]' string by using the REPLACE command, but converting the remaining yyyymmdd string has got me stumped! Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
| Convert Text Entry to Date Format | Excel Discussion (Misc queries) | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| Macro to convert text to date | Excel Worksheet Functions | |||
Linear Mode
