Thread: Find and Replace - delete the remainder of the text in the cell after my Find
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Find and Replace - delete the remainder of the text in the cell after my Find
On Fri, 03 Aug 2007 14:45:46 -0700, wrote:

I want to Find characters "temporary=*" in cells with * being a
wildcard. The text after "temporary=" could vary per cell.

Then I want to Select that text and delete it from the cell. I still
want the characters that appear before "temporary=*."

Any suggestions?

Thanks,

Nick


=LEFT(A1,FIND("temporary=",A1)-1)


--ron
Reply With QuoteReply With Quote