Delete a character using an IF statement

[martian]

Hi all,

Can anyone give me advice on how to clean up a dataset? The problem is that the dataset contains lots of entries that are not formatted correctly (e.g. I have entries like "United States " [note the space at the end] instead of "United States").

Can anyone tell me how I can ask Excel to delete spaces at the end of strings (but only at the end and not in the middle)? I imagine this involves some sort of IF statement, but I really don't know where to begin.

Thanks in advance for any assistance...

[teylyn]

Try

=trim(A1)

adjust range to suit and copy where you need it.

[martindwilson]

select the column
then data /text to columns
choose fixed width
click next
double click on any break lines to remove them
in the same place click anywhere to right of your data to insert break line(making sure its as least as far over as to include your longest cell string.)
click finish