Hello ….
I’m working in some tables and I’d like to pick-up from a column where are deferent inputs (characters, numbers, dates etc) only the dates…which will constitute my new column “output
See the attached file
Hello ….
I’m working in some tables and I’d like to pick-up from a column where are deferent inputs (characters, numbers, dates etc) only the dates…which will constitute my new column “output
See the attached file
Hi
Format column A as text. Then in B5 and copy down use this.
=IF(ISERROR(DATEVALUE(A5))=FALSE,A5,"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
HI Sokol,
Your request is not clear to me, please elaborate using an example.... thanks.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Also, I found your another similar post
http://www.excelforum.com/excel-prog...haracters.html
Regards,
DILIPandey
<click on below * if this helps>
Thanks Dilip. The duplicate thread has been closed. You can now continue in this thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks