Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Excel or open office calc how to remove last white space?

share|improve this question

closed as not a real question by Mehper C. Palavuzlar, harrymc, random Jul 18 '10 at 0:36

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

More detail please. Do you want a formula to remove the last white space character from a given cell/string? Do you mean any white space or just a normal space character? Is the space always trailing, or somewhere in the string body? – AdamV Jul 16 '10 at 9:24
Who in their right mind would upvote this "question"? – random Jul 18 '10 at 0:36
I came here searching for "remove trailing white space openoffice calc" - The Trim function that kikbira suggested worked a charm. - So I think the question is a good one - how ever badly phrased. – Andreas Mar 14 '11 at 12:28

Try Trim() function

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.