I have a column in an excel document that each entry has a trailing space. When I copy/paste the value into another form I have to manually remove the trailing space. Is there an easy way to batch remove all the trailing spaces through an entire column?
Its a 2 step process:
Use the TRIM function
To remove the spaces. Basically make a parallel column that is TRIMmed. Copy the trimmed cells, then
Clarified step by step:
If the content is numeric values with trailing spaces you can select the column, edit>copy and into another column paste special>values>add and skip doing the trim. If it is text, do as mentioned previously by JNK