Thread: Duplicate phrases in one cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
  
Posts: 5,600
Default Duplicate phrases in one cell
"Ron Rosenfeld" wrote in message
=IF(LEFT(A1,LEN(A1)/2)=RIGHT(A1,LEN(A1)/2),LEFT(A1,LEN(A1)/2),A1)

Very simple, and neat.
--ron

Why thank you Ron.

Yours is very clever :-)

Regards,
Peter T


Reply With QuoteReply With Quote