Thread: Special Characters
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Special Characters
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"#",""),"\"," "),"@","")


"sandyboy" wrote:

Is there a function in excel that removes special characters (ie: # \ @) from
a cell? Would appreciate prompt reply.

Thanks,

--
sandyboy
Reply With QuoteReply With Quote