making sure a cell is empty

[huorsa]

How can I make sure that a cell is empty. I am concatenating several cell separated by "|" symbol and when a cell is emppty the concatenation should be || but sometimes I get | |, I don't know why because the cell looks empty.

I want to avoid the space between the pipes if the cell is empty.

Hugo

 

[Anne Troy]

The TRIM function removes non-printing characters such as spaces and paragraph returns. But it only removes them before and after *real* characters, and not from in between *real* characters.

_________________
TheWordExpert
This message was edited by Dreamboat on 2002-02-23 11:50

 

[Aladin Akyurek]

On 2002-02-23 11:49, Dreamboat wrote:
The TRIM function removes non-printing characters such as spaces and paragraph returns. But it only removes them before and after *real* characters, and not from in between *real* characters.
This message was edited by Dreamboat on 2002-02-23 11:50

Enter in A1:B1 the following:

{" ",
2}

That is, a space in A1 and 2 in B1.

In C1 enter:

="|"&TRIM(A1)&"|"&TRIM(B1)

Please report back the result in C1.
This message was edited by Aladin Akyurek on 2002-02-28 16:32
This message was edited by Aladin Akyurek on 2002-02-28 16:33