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

:* smitha.kumari smitha.kum...@speridian.com *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 ** ** Regards Smitha/ Senior

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

@googlegroups.com *Subject:* Re: $$Excel-Macros$$ remove a certain text from every sentence* *** ** ** Use This command ** ** [image: image.png] Thanks with ** ** Mothilal.J -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate

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

Use editreplace 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 remove

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

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 sentence

$$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 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 already

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

...@speridian.com Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 10:39:15 To: excel-macros@googlegroups.com 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

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

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

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

@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 RULES

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

you can use find replace. On 10 November 2011 10:39, smitha.kumari smitha.kum...@speridian.comwrote: Hi, ** ** I want to remove a certain text from every sentence Technology Company:David Technology Company:Arya Technology Company:Jose ** ** I need only the

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

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