Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Dates
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Dates
Resolved · Low Priority · Version 2007
ReplyFor upcoming training course dates see: Pricing & availability
RE: dates
Hi Dips, thanks for your query. Separating any string such as a date is called "parsing" and you'll need your Left, Right, Mid and LEN functions to do so if there is no delimiter. If all your dates are 6 digits you could simply use the MID function in three separate cells with the following basic syntax:=MID(A1, 1, 2)
You use the LEN function when the dates are, say, 6 and 7 characters long and you need to count the string length and, using an IF statement to channel the outcome, chop up the dates in slightly different ways. If you have a live example of this you need help with, feel free to post.
Hope this helps,
Anthony
Mon 1 Mar 2010: Automatically marked as resolved.
|
