Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Forums › Off topic › Excel Formula help


484 posts

Ultimate Geek

Trusted

Topic # 32990 28-Apr-2009 11:47
Send private message

Hi guys,

I am trying to populate a worksheet with text in cells from another spreadsheet.  How do I get the formula to ignore blank cells?

At the moment I am using a simple =Sheet1!I3 type formula but the is reutrning cells which have nothing in them.

A little help would be most appreciated!




For billions of years since the outset of time, every single one of your ancestors survived, every single person on your Mum and Dads side, successfully looked after and passed onto you life.  What are the chances of that like?

Create new topic
3290 posts

Uber Geek
+1 received by user: 209

Trusted

  Reply # 210385 28-Apr-2009 23:04
Send private message

I usually use an =IF(ISBLANK(A1),"",A1) type thing, but bear in mind that the destination cells won't be empty (i.e. ISBLANK = TRUE) after that, if that's important.



484 posts

Ultimate Geek

Trusted

  Reply # 210566 29-Apr-2009 15:31
Send private message

Thanks dude, worked great




For billions of years since the outset of time, every single one of your ancestors survived, every single person on your Mum and Dads side, successfully looked after and passed onto you life.  What are the chances of that like?

Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Geekzone Live »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.