you should use vbnullstring, which as almost the same as "", either would do, you should then have empty cells

i do not know why you can not replace the ~ character, seems to be just one of those things, i just chose that character at random, any other character should do the same job and most should be replaceable, try x instead