Replace Underscores characters with Space inside a String value

Question

This is a rather simple question. I have a date variables formated like: `25_December_2010` I would like a statement or a bit of code in the `VBA macro` that will transform that string value from: `25_December_2010` to `25 December 2010`. Somehow be able to remove the `underscores` from inside the `String` value....

Accepted Answer

As I mentioned in comments, use code below:

```
Dim strDate As String
strDate = "25_December_2010"
strDate = Replace(strDate,"_"," ")
```

Replace Underscores characters with Space inside a String value

Solution

Problem