Thread: Letter Replace Help!!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Letter Replace Help!!
try

=LEFT(A1,FIND("D",A1)-1)&"E"&RIGHT(A1,LEN(A1)-FIND("D",A1))
Reply With QuoteReply With Quote