View original (French)

Trim whitespace at end of cell

Solved
Qhes Posted messages 180 Status Membre -  
Mike-31 Posted messages 18405 Registration date   Status Contributeur 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 réponses

Réponse 1 / 2
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
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