up vote 1 down vote favorite
1
share [g+] share [fb]

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

link|improve this question
1  
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
feedback

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. See the FAQ for guidance on how to improve it.

1 Answer

up vote 2 down vote

Try Trim() function

link|improve this answer
feedback

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