Remove blank value

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

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

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

2 Likes

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

Example:

image

RESULT
image