How to remove trailing spaces from text within a cell
When typing names or words, you might hit the space bar after the last word resulting in a trailing space. This can cause errors when trying to perform look up functions to match data or look up data in adjacent cells also related to the record.
For example: to a look up function in excel,
Mrs(SPACE)Alice(SPACE)Smith
is not the same as
Mrs(SPACE)Alice(SPACE)Smith(SPACE)
and can return an error or not found value. This can be corrected so that the two instances of the name above match exactly by removing the trailing space.
To do this:
Use =trim()
If text is in cell A1, use =trim(A1)













