Trying to extract a date over 4000 times
I have a code # which contains the date, but I need this date seperate and in short date format. I got the macro to work for the first cell but when I try to loop next it just copies the whole of cell A2 into B2, I want to copy and paste specific parts in a specific order from A2 to B2, then A3 to B3, and so on.
Please Login or Register to view this content.
Last edited by arlu1201; 06-13-2013 at 01:03 PM. Reason: Replaced quote tags with code tags.
Will the starting of the date always be at the same location for every row? For e.g. starting at the 6th or 7th character of the text?
Why do you want to use macro? You can do this easily by formulae?
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]
Yes it will.
And no reason, I did not know I could use a formula.
If your data starts in A2 and your date in that text starts from the 6th character, use this formula in B2
and drag down to the remaining rows.Formula:
Please Login or Register to view this content.
How will I put that in a date format?
In another column (C), I am using theformula to get the # of days since the date has passed.=TODAY()-B1
HI eskyec,
If you have date in B1, use below formula:-
Formula:Please Login or Register to view this content.
see attached:-extracting date from a text.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks