Thread: taking out all \/?*[] so input can be name of worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mechif@gmail.com is offline
external usenet poster
  
Posts: 10
Default taking out all \/?*[] so input can be name of worksheet
Hi!
I'm reading in a CSV file. I want to use one of the fields as the
name of the WorkSheet. The file is from different clients and the
field is free text. I've come across names with ** or \. Do I have
to use the SUBSTITUTE function 6 times or is there a replaceText
function?
Thanks,
Mechi
Reply With QuoteReply With Quote