Thread: Delete etxra information from cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default Delete etxra information from cells
=LEFT(A2,FIND("com",A2)+2)

--
Kind regards,

Niek Otten

"Shani" wrote in message oups.com...
|I need to delete information in cell
|
| for example if A2= http://google.com/help/you/me
|
| I want to remove everything after "com"
|
| So i would want A2 = http://google.com
|


Reply With QuoteReply With Quote