PPRuNe Forums - View Single Post - Yet another Excel question..

27th December 2007 | 19:40

#4 (permalink)

Jhieminga

Joined: Mar 2002

: CPL

Posts: 3,392

Likes: 325

From: near an aeroplane

I would've gone for the IF statement as well, just slightly different:

IF(B1<>"";B1;"")

No need to put a space in there, Excel can identify an empty field this way and also leave the cell empty if B1 is empty

Reply

0