Thread: 'Substitute' function with wildcards
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jasontferrell jasontferrell is offline
external usenet poster
  
Posts: 56
Default 'Substitute' function with wildcards
I don't think wildcards work in substitute. You could instead use
something like this for a one instance replacement:
=LEFT(A1,FIND("FY20",A1)-1)&"FY2008"&MID(A1,FIND("FY20",A1)+6,999)
Reply With QuoteReply With Quote