I have an excel file with thousands of cells containing product descriptions.
some cells have spaces in them that need to be cleaned out. the space is always found for the point charactar (046) AND/OR on the next line of the description for instance :
Afmetingen: 13,5x33 cm .
Pagina-indeling: 1 dag over 2 pagina's.
this cell has a space before the point. i would like the point to be against the text.
i tried excel function replace " ." by "." but that doesn't work.
Also on the beginning of the next line, just before "Pagina..." there's a space character. this space character has to go as well.
extra note : there's ALWAYS an line feed behind the point of the previous line. so the find replace could be:
replace "point+line feed+space" by "point+line feed" but that also doesn't work.
i would like a macro or something which allows me to select the cells and that replaces these obsolete characters.
Does anyone know how to do this