View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Raja Mahendiran S Raja Mahendiran S is offline
external usenet poster
 
Posts: 1
Default =SUBSTITUTE(C4,"~?#","") will this work to remove multiple string

Hi All,

I need to remove multiple string (special characters) in an excel field.

Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this
without using Nest Function.

Please help!!!

Thank You