remove underscore if there is one

[Hallet]

Hello experts,

I'm fairly new to vba and programming in general, sorry if this seems trivial
I just need something that will remove an underscore in a string if there is one. Not sure if after removing the underscore, it will be replaced by space, if that's the case, I need to collapse the string together so there's no spaces present.
ex: "WILLIAM_ABERHART" to "WILLIAMABERHART"

Thank you for your time,

Hallet

[StevenM]

Replace("WILLIAM_ABERHART", "_", "")

[tigeravatar]

Hallet,

Formula solution:

Please Login or Register  to view this content.

VBA solution:

Please Login or Register  to view this content.

[Hallet]

Thanks very much!