How to remove a character using Excel function

dogdog3 · #1 Aug 5, 2006, 05:40 AM

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

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 · Aug 5, 2006, 05:46 AM

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 · Aug 5, 2006, 05:48 AM

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.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!