How can i delete spaces?

  • How I delete spaces that are in an excel form within a cell? The spaces are not located in the beginning or end of the cell. Heres an example.

    Ex. In a excel spreadsheet in column A, Cell 1 the cell reads : M-TK / F

    I would like it to read : M-TK/F (notice the spaces inbetween the "/" are gone.

  • Hi arashaloha,

    You could use the Edit > Replace dialog (CTRL+H) ,where,
    Search for : [blank]/[blank]
    Replace with : /

    Obviously the use of [blank] is to illustrate an intentionally space.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!