Thread: Using substitute to replace text that varies
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
schuurke28[_2_] schuurke28[_2_] is offline
external usenet poster
  
Posts: 1
Default Using substitute to replace text that varies

substitute is the right command but you must ommit the last parameter
'Instance_num'

i.e.:

=SUBSTITUTE(A1;"X";"Y")

This will replace all X by Y in the text


--
schuurke28
------------------------------------------------------------------------
schuurke28's Profile: http://www.excelforum.com/member.php...o&userid=15818
View this thread: http://www.excelforum.com/showthread...hreadid=273154

Reply With QuoteReply With Quote