On 2002-02-23 11:09, huorsa wrote:
On 2002-02-23 00:38, Aladin Akyurek wrote:
On 2002-02-22 17:58, huorsa wrote:
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
Care to post the formula that you use?
Aladin:
I am using this code in VB
acumular2 = ActiveCell.Offset(0, 0) & "|" & ActiveCell.Offset(0, 1) & "|" & ActiveCell.Offset(0, 2) & "|" & ActiveCell.Offset(0, 3) & "|"
but sometimes the cell looks empty, but it isn't (it is like pressing the space bar in the cell, it looks empty because you haven't write any characters, but it is not empty because you press the space bar).
Instead og getting: HI|how||you| I get
HI|how| |you|
I want to avoid the second one.
It is a big range thaat is why I can't check cell by cell and deleted manually.
Hugo