Fwd: $$Excel-Macros$$ Fwd: Need Change!

2010-11-15 Thread amrahs k
Hi, Any update on the below email? I am awaiting for your response. It would be great if you could share this by today. Thanks, Sharma -- Forwarded message -- From: amrahs k Date: Mon, Nov 15, 2010 at 2:54 PM Subject: Re: $$Excel-Macros$$ Fwd: Need Change! To: excel-macros

Re: $$Excel-Macros$$ Fwd: Need Change!

2010-11-15 Thread amrahs k
Hi, Thanks for the swift response. I came up with different scenario after applying the new function that you shared me. Input: DECLARATION BY LAW ENFORCEMENT FOR WALK-THROUGH ARREST WARRANT AND ORDER Output: Declaration by Law Enforcement for Walk-through Arrest Warrant and Order Input: SETTLEME

Re: $$Excel-Macros$$ Fwd: Need Change!

2010-11-13 Thread roberto mensa
try this function changed Function ProperCase_r( _ ByVal s As String) As String '__ '¯¯ 'https://sites.google.com/site/e90e50/vbscript/regexp '__ '¯¯¯

$$Excel-Macros$$ Fwd: Need Change!

2010-11-13 Thread amrahs k
Hi, First I would like to say thank to you. The script that you had given to me works fine though I have a constraint as- The below code is does not handle "(" in the input. Please look into the below example. *Input: CASE MANAGEMENT CONFERENCE QUESTIONNAIRE (LOCAL RULE 12.7)* *Output: Case Man