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)<#129ed0f5a433f98c_group_thread_0>[2 Updates] > - Create a Unique Name List <#129ed0f5a433f98c_group_thread_1> [2 > Updates] > - VBA code for importing data from excel to Access > table<#129ed0f5a433f98c_group_thread_2>[2 Updates] > - automation error <#129ed0f5a433f98c_group_thread_3> [1 Update] > - Excel data into power point <#129ed0f5a433f98c_group_thread_4> [1 > Update] > - Personal Macro giving serious problem to > excel<#129ed0f5a433f98c_group_thread_5>[1 Update] > - Index match with 3 criteria <#129ed0f5a433f98c_group_thread_6> [2 > Updates] > - excel to send auto mail <#129ed0f5a433f98c_group_thread_7> [1 Update] > - Creating a macro for Parsing text <#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 > ^<#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 > ^<#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 > ^<#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 ^<#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 > ^<#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 ^ <#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 > ^<#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 > ^<#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 > ^<#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 > ^<#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 > ^<#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 > ^<#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 > ^<#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 -- ---------------------------------------------------------------------------------- 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
