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

1

1

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

kampit

Posted 2010-07-16T08:41:21.703

Reputation: 19

Question was closed 2010-07-18T00:36:19.073

1More 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 – 2010-07-16T09:24:17.763

Who in their right mind would upvote this "question"? – random – 2010-07-18T00:36:42.473

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 – 2011-03-14T12:28:19.607

Answers

2

Try Trim() function

kokbira

Posted 2010-07-16T08:41:21.703

Reputation: 4 883