Thread: Apostrophe Dilemma
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Saxman[_2_] Saxman[_2_] is offline
external usenet poster
  
Posts: 33
Default Apostrophe Dilemma
I'll give it a whirl Thursday, thanks!

On 07/08/2007 17:17:48, "Peo Sjoblom" wrote:


=SUBSTITUTE(SUBSTITUTE(UPPER(TRIM(LEFT(A3,MIN(FIND ({0,1,2,3,4,5,6,7,8,9,"("},A3&"0123456789("))-1))),"'",
""),"´","")

Reply With QuoteReply With Quote