REPLACE " WITH BLANK

User avatar
sal21
PlatinumLounger
Posts: 4355
Joined: 26 Apr 2010, 17:36

REPLACE " WITH BLANK

Post by sal21 »

I have this string:
AG."A" 12547

i need:

AG. A 12547

in effect replace " with blank space
Top
User avatar
HansV
Administrator
Posts: 78493
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: REPLACE " WITH BLANK

Post by HansV »

yourvariable = Replace(yourvariable, Chr(34), " ")
Best wishes,
Hans
Top
User avatar
sal21
PlatinumLounger
Posts: 4355
Joined: 26 Apr 2010, 17:36

Re: REPLACE " WITH BLANK

Post by sal21 »

HansV wrote:yourvariable = Replace(yourvariable, Chr(34), " ")
Nice! with Chr solution....
Top

Return to “VB/VBA/.Net/Office Scripting”