tag:blogger.com,1999:blog-4165587777214115821.post6504157503699299187..comments2023-06-11T04:58:42.501-04:00Comments on Your Excel Expert: MidTricia Rothhttp://www.blogger.com/profile/16617232875055299624noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-4165587777214115821.post-48322611985370576302010-03-01T22:53:12.686-05:002010-03-01T22:53:12.686-05:00This comment has been removed by a blog administrator.英文發音真難https://www.blogger.com/profile/05768391858187242400noreply@blogger.comtag:blogger.com,1999:blog-4165587777214115821.post-37882586806200943552010-02-04T05:06:00.168-05:002010-02-04T05:06:00.168-05:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4165587777214115821.post-89516651703248672972010-01-15T06:08:32.773-05:002010-01-15T06:08:32.773-05:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4165587777214115821.post-58591377553672388622009-12-25T07:23:50.693-05:002009-12-25T07:23:50.693-05:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4165587777214115821.post-57026343347869129282009-04-03T09:04:00.000-04:002009-04-03T09:04:00.000-04:00I use MID, RIGHT and LEFT in combination with Find...I use MID, RIGHT and LEFT in combination with Find. <BR/><BR/>For example, if I want to separate first name and last name, on a list of names, I use LEFT (1,{find space}) to get the first name and Right({find space}, {max number}) to find the last name. <BR/><BR/>Many times, I use MID to extract dates out of a text field like "20081201 12:54 AM" and reconstruct date. E.g. DATE (use mid for YEAR, use MID for MONTH, use MID for DAY). <BR/><BR/>I would love to know if you have other uses of mid.Chaitanya Sagar, Excel Experthttp://www.p2w2.com/chaitanya_sagar/index.phpnoreply@blogger.comtag:blogger.com,1999:blog-4165587777214115821.post-4274503147034133972008-11-07T02:35:00.000-05:002008-11-07T02:35:00.000-05:00Isn't this MID function a generalization of the LE...Isn't this MID function a generalization of the LEFT and RIGHT functions? Just use MID(A2,1,8) to get the same result as LEFT(A2,8)? I guess using MID for RIGHT might be more annoying if it's a long string of characters, but using MID(A2,11,7) isn't too bad, right?<BR/><BR/>Anyway, just a thought. Pretty useful functions! =)normalboyhttps://www.blogger.com/profile/17869276853132343136noreply@blogger.com