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.


    Cheers
    Andy

    [h4]Cheers
    Andy
    [/h4]

Participate now!

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