Remove blank value

[Sana_Afreen (Sana)]

I want to replace " " to “”“”. There are 2 empty space between the quote. I want to replace it with “”

[rkelchuri (ER.Krishna)]

@Sana_Afreen you can use Replace function.
Replace(string,find,replacewith[,start[,count[,compare]]])
txt=“This is a beautiful day!”
Replace(txt,“beautiful”,“fantastic”)

[ppr (Peter)]

@Sana_Afreen
a replace of two blanks (spaces) with two quotations (“”) can be done as following:

[jack.chan]

use
str.Replace(" ",Chr(34))
Chr(34) represents a double quote "

Example:

RESULT