Thread: HELP I need a function or macro to crop cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_14_] Bob Phillips[_14_] is offline
external usenet poster
  
Posts: 216
Default HELP I need a function or macro to crop cells
=LEFT(A1,FIND(" ",A1))&MID(A1,FIND("~",SUBSTITUTE(A1,"
","~",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Shani" wrote in message
oups.com...
Example If cell A1= STEPHEN R WILSON
I would like A1=STEPHEN WILSON



Reply With QuoteReply With Quote