There is nothing special to do... Just use Text to Column option and use Delimited and then put - in others. click on next next and your data will be separated...
REgards Amit Jindal On Tue, Jul 20, 2010 at 8:07 AM, Ashish kaushik <kaushikaash...@gmail.com>wrote: > can we separate the numbers n alphabates from a cell. > ie for ex. if we have Nehru place-1100048 in a cell then can we separate it > into 2 cell of one cell hv Nehru place n other cell hv 1100048. > On Tue, Jul 20, 2010 at 5:04 AM, > <excel-macros+nore...@googlegroups.com<excel-macros%2bnore...@googlegroups.com> > > wrote: > >> Today's Topic Summary >> >> Group: http://groups.google.com/group/excel-macros/topics >> >> - Microsoft Most Valuable Professional >> (MVP)<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_group_thread_0>[2 >> Updates] >> - Create a Unique Name >> List<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_group_thread_1>[2 >> Updates] >> - VBA code for importing data from excel to Access >> table<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_group_thread_2>[2 >> Updates] >> - automation >> error<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_group_thread_3>[1 >> Update] >> - Excel data into power >> point<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_group_thread_4>[1 >> Update] >> - Personal Macro giving serious problem to >> excel<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_group_thread_5>[1 >> Update] >> - Index match with 3 >> criteria<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_group_thread_6>[2 >> Updates] >> - excel to send auto >> mail<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_group_thread_7>[1 >> Update] >> - Creating a macro for Parsing >> text<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_group_thread_8>[1 >> Update] >> >> Topic: Microsoft Most Valuable Professional >> (MVP)<http://groups.google.com/group/excel-macros/t/e7c2fe28ad93be06> >> >> Vinod N <nvino...@gmail.com> Jul 19 02:21PM +0530 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> >> Hi Team, >> >> How about nominating Ayush, Dilip, Ankur and Dave for Microsoft MVP... >> >> http://mvp.support.microsoft.com/gp/mvpnominate >> >> >> -- >> Thanks and Regards >> >> Vinod N >> more...<http://groups.google.com/group/excel-macros/msg/903a23400c83a40a> >> >> >> Dave Bonallack <davebonall...@hotmail.com> Jul 20 07:20AM +0800 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> >> Hi Vinrod, >> >> Kind of you to say so, but really really not interested (and certainly >> not qualified). >> >> Regards - Dave. >> >> >> >> From: nvino...@gmail.com >> Date: Mon, 19 Jul 2010 14:21:12 +0530 >> more...<http://groups.google.com/group/excel-macros/msg/e2c7188746ca3ad6> >> >> Topic: Create a Unique Name >> List<http://groups.google.com/group/excel-macros/t/ae6c8bab33a0acfb> >> >> saggi <realsa...@gmail.com> Jul 18 09:46PM -0700 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> Consolidate data in one place n Run Pivot >> more...<http://groups.google.com/group/excel-macros/msg/39d7322158508a1d> >> >> >> who <dlanm...@att.net> Jul 19 05:43AM -0700 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> Hi, >> >> Want to post a work book? This should be not too difficult. >> >> Thanks, >> David >> >> more...<http://groups.google.com/group/excel-macros/msg/f8abd8ff2bb889cb> >> >> Topic: VBA code for importing data from excel to Access >> table<http://groups.google.com/group/excel-macros/t/b229d14ee75084c7> >> >> debasish <debasis...@gmail.com> Jul 18 10:20PM -0700 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> I am a novice in macro... could you please elaborate more on this.. >> >> Thanks & regards, >> Debasish >> >> more...<http://groups.google.com/group/excel-macros/msg/c04430b8a4cfcaec> >> >> >> "Kishan Reddy, K" <kishanreddy.kethire...@gmail.com> Jul 19 04:30AM >> -0700 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> Hello, >> >> Very simple. >> >> Select the macros tab. >> >> click on the new button. Macro window will appear. >> >> In actions column select 'TRANSFERSPREADSHEET'. >> >> In action arguments column - >> more...<http://groups.google.com/group/excel-macros/msg/79307f8ac49c4781> >> >> Topic: automation >> error<http://groups.google.com/group/excel-macros/t/d1b7abe33dcb4b6e> >> >> mohd ateeq <atee...@gmail.com> Jul 19 04:52PM +0530 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> HI all, >> Can anyone help me out with the following error: >> Run-time error ‘-2147417848 (80010108)’: >> Automation error >> The object invoked has disconnected from its clients >> It occurs when I create >> more...<http://groups.google.com/group/excel-macros/msg/4101bb7aad97640> >> >> Topic: Excel data into power >> point<http://groups.google.com/group/excel-macros/t/2491a32c3d3727f1> >> >> bhavya khanna <bhavya...@gmail.com> Jul 19 11:30AM +0530 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> Hi Everyone. >> >> how can i past data of excel into powerpoint using vba. can you send >> me that >> sheet using both of them >> >> Thanks and regards >> more...<http://groups.google.com/group/excel-macros/msg/b4247fd2f11be790> >> >> Topic: Personal Macro giving serious problem to >> excel<http://groups.google.com/group/excel-macros/t/a23bc75788683bbf> >> >> saggi <realsa...@gmail.com> Jul 18 10:05PM -0700 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> This Problem Generally come with OS Xp >> more...<http://groups.google.com/group/excel-macros/msg/4bcfca8a82a46248> >> >> Topic: Index match with 3 >> criteria<http://groups.google.com/group/excel-macros/t/6c7cb87559f8311e> >> >> Nadine S <n8dine4ma...@yahoo.com> Jul 18 01:22PM -0700 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> Thank you. This worked! WooHoo! >> >> >> >> >> ________________________________ >> From: Dave Bonallack <davebonall...@hotmail.com> >> To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> >> more...<http://groups.google.com/group/excel-macros/msg/7199bb2408ff3569> >> >> >> Dave Bonallack <davebonall...@hotmail.com> Jul 19 01:16PM +0800 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> You're welcome. >> >> Regards - Dave. >> >> >> >> Date: Sun, 18 Jul 2010 13:22:42 -0700 >> From: n8dine4ma...@yahoo.com >> Subject: Re: $$Excel-Macros$$ Index match with 3 criteria >> more...<http://groups.google.com/group/excel-macros/msg/d83b080ba9b96a7d> >> >> Topic: excel to send auto >> mail<http://groups.google.com/group/excel-macros/t/4ddab0e067153306> >> >> "Soni.Rajender" <soni.rajen...@gmail.com> Jul 18 09:15PM -0700 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> Hi >> >> Please visit the below link: >> >> http://www.mrexcel.com/forum/showthread.php?t=85596 >> >> Regards >> Rajender Soni >> >> more...<http://groups.google.com/group/excel-macros/msg/7db5bf06ce82d0d4> >> >> Topic: Creating a macro for Parsing >> text<http://groups.google.com/group/excel-macros/t/a715b35514e84eaa> >> >> "uojemeni" <uojem...@gmail.com> Jul 18 09:13PM +0100 >> ^<http://mail.google.com/mail/?ui=2&view=js&name=main,tlist&ver=Gdx0W-4kZg4.en.&am=!L9LcuAB3v6axhfwb0PImspvMfG2gTcE5Zf5A9x3lS4YY2Id1Ip8&fri#129eddf9d688ec97_129ed0f5a433f98c_digest_top> >> >> Thank you for the email. >> >> using the delimiting function would be rather difficult when >> condsidering the attached. I would appreciate any assistance in parsing >> the >> attached(this is different from >> more...<http://groups.google.com/group/excel-macros/msg/bde93c570f2aa7a> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > > > -- > Warm Regards, > > Ashish Kaushik > > Gopal Nagar > http://mGinger.com/index.jsp?inviteId=kaushikaashu16<http://mginger.com/index.jsp?inviteId=kaushikaashu16> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks Amit Jindal Mob. 0 98730 13724 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
