Thread: Urgent
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Urgent
Try
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-",""),".","")

Frank


Hi Frank



=SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-","")


This is close but I need to remove one more charater..."."


---
Message posted from http://www.ExcelForum.com/


Reply With QuoteReply With Quote