1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Formula needed to skip blanks

Discussion in 'Business Applications' started by Gary09, Feb 14, 2013.

Thread Status:
Not open for further replies.
  1. Gary09

    Gary09 Thread Starter

    Joined:
    Feb 14, 2013
    Messages:
    1
    Excel Formula needed to skip blanks and paste..

    Sample
    row in tab1(below nodes are dynamic they will change every time we refresh the report and also total count)

    A123 ____ B123 C123 ____ D123

    result in tab2
    A123 B123 C123 D123

    I require to write a formulae because it needs automation and not one time activity

    Please help
     
  2. 20_2_Many

    20_2_Many

    Joined:
    Jun 29, 2012
    Messages:
    518
    Please identify what version of Excel you are using, and select the Go Advanced button then the paperclip to attach a sample copy of the workbook (without sensitive data). In the new description when you post, please provide a detailed explanation of what you are starting with and what you hope to achieve. Hopefully this will trigger a response you can use.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1089517

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice