I am working in a large excel doc. It has columns for first names and last names. I've concatenated the two columns, but noticed in the "First name" column some values have extra spaces at the end, which makes for awkward formatting:
John__Doe instead of John_Doe.
What formula can I use to identify all cells with a space as the final character, and then replace that space with nothing? What is the =if() formula?