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

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

Select the column...go to find and replace...(CTRL+F) type the technology company in space for find and keep blank in the space provided for replace...then replace all. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -Original Message- From: smitha.kumari

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