Results 1 to 2 of 2

formulas skipping empty cells

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2009
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    84

    Question formulas skipping empty cells

    I 'm using a formula to join to cells "A" and "B" (text) and I"m using the following formula =A&,","&B (which i'm using to join first name and last name). I have about 3000 records that I need to run this formula but I want to have a macro or code that will apply that formula only on those rows that have data. Otherwise if empty then skipp the row.

    you have are a great help and I hope you guys can help me with one. thanks a bunch in advace.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1