View original (French)

Trim whitespace at end of cell

Solved
Qhes Posted messages 180 Status Member -  
Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   -
Hello,

I have a range of cells.
Some have a space at the end and others do not.

I can't use the remove duplicates function...

Does anyone know if it's possible to remove that space? Or to copy all the cells without the trailing space?

Note: not all cells have the same number of characters.

Configuration: Windows 7 / Internet Explorer 8.0

2 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hello,

    To remove spaces at the beginning and end of a value, there is the TRIM function for the value in A1, copy the formula and drag down

    =TRIM(A1)

    --
    A+
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    12