;
> - 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
&
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
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 remove
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
>
>
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
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
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
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
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"
Sender: excel-macros@
