Re: $$Excel-Macros$$ remove a certain text from every sentence

2012-02-24 Thread Shekhar Sharma
; > - Original Message - > *From:* smitha.kumari > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, November 10, 2011 11:32 AM > *Subject:* RE: $$Excel-Macros$$ remove a certain text from every sentence > > The result should be david and not Technology company &

Re: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-10 Thread Mukesh Kumar Jha
Hi Smitha, Try below formula =RIGHT(A1,LEN(A1)-FIND(":",A1)) Thanks Mukesh - Original Message - From: smitha.kumari To: excel-macros@googlegroups.com Sent: Thursday, November 10, 2011 11:32 AM Subject: RE: $$Excel-Macros$$ remove a certain text from every senten

Re: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-10 Thread dguillett1
Use edit>replace as suggested by Sandeep Chhajer. Don Guillett SalesAid Software dguille...@gmail.com From: smitha.kumari Sent: Wednesday, November 09, 2011 11:09 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ remove a certain text from every sentence Hi, I want to rem

Re: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-10 Thread jmothilal
ent:* Thursday, November 10, 2011 11:17 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ remove a certain text from every sentence* > *** > > ** ** > > Use This command > > ** ** > > [image: image.png] > > Thanks with > >

Re: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-09 Thread Haseeb Avarakkan
Hello Smitha; If you need a formula use, =REPLACE(A1,1,FIND(":",A1),"") Or Select your data, press CTRL+H; Find What: **:* Click Replace All Hope this helps Haseeb -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like P

Re: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-09 Thread harsh shah
you can use find & replace. On 10 November 2011 10:39, smitha.kumari wrote: > Hi, > > ** ** > > I want to remove a certain text from every sentence > > Technology Company:David > > Technology Company:Arya > > Technology Company:Jose > > ** ** > > I need only the name, “Techno

RE: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-09 Thread smitha.kumari
macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jmothilal Sent: Thursday, November 10, 2011 11:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ remove a certain text from every sentence Use This command image.png Thanks with Mothilal.J -- FORUM

Re: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-09 Thread jmothilal
Use This command [image: image.png] Thanks with Mothilal.J -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention o

Re: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-09 Thread chhajersandeep
cel-macros@googlegroups.com Date: Thu, 10 Nov 2011 10:39:15 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ remove a certain text from every sentence Hi, I want to remove a certain text from every sentence Technology Company:David Technology Company:Arya

$$Excel-Macros$$ remove a certain text from every sentence

2011-11-09 Thread smitha.kumari
Hi, I want to remove a certain text from every sentence Technology Company:David Technology Company:Arya Technology Company:Jose I need only the name, "Technology Company:" has to be removed from every cells. Please reply. Regards Smitha -- FORUM RULES (925+ members alread