[dogdog3]

Could anyone know if there is any Excel function that I can use to remove a certain character from a text string, e.g.

1). Remove space from "acurve is what"
2). Remove "-" from "acurve-is-what"
3). Remove "'" from "acurve'is"
And so on.

Thanks a lot!

[Curlyben]

Have you tried the replace function ?
It's located in Edit > Replace or Ctrl-H.
Just specify the character you want to remove and what, if anything, you want to change it to.

[dogdog3]

Thanks a lot

But you can replace a space with only a space or other character, not "remove" it... So how can I remove it?

Thanks a lot. I figured out. It works.

[ScottGem]

Just leave the Replace with part blank.