Thread: udf to convert <any text to range name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default udf to convert <any text to range name
Hi David

Not a UDF but a formula
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"2","_"),")", "_"),"(","_")
--
Regards

Roger Govier


"David" wrote in message
...
Greetings,
Has anyone got a ready made UDF to convert say "2goa(T)" to "_goa_T_"
TIA
--
David


Reply With QuoteReply With Quote