How can i delete spaces?

arashaloha · Jan 7th 2004

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.

**Andy Pope** · Jan 8th 2004

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

Participate now!