Thread: Replace wildcard character problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daddy Sage Daddy Sage is offline
external usenet poster
  
Posts: 24
Default Replace wildcard character problem
My colleague has some texts written like

*Abe
*Benzen
*Munoni
*Monintor

and so on. Now he want to change the texts to

*Abe*
*Benzen*
*Munoni*
*Monintor*

I have problems making it work because of * being a wildcard character.
Reply With QuoteReply With Quote