+ Reply to Thread
Results 1 to 5 of 5

How to combine multiple ideas

  1. #1
    Registered User
    Join Date
    12-05-2011
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2010
    Posts
    8

    How to combine multiple ideas

    I have a formula that works well, it is written to replace a section of data in a cell. it is =REPLACE(F3, 8, 1,1) =REPLACE(Cell range to evaluate , where to start, how many to replace , what to replace with )

    I need to run this formula down an entire range of cells, and I want it to ignore any cell that is blank. I'm not sure how to combine the isblank function with the above formula to get the desired result.
    can somebody help me ?

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: How to combine multiple ideas

    how about just this IF statement added to it... =IF(F3="","",REPLACE(F3,8,1,1))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: How to combine multiple ideas

    Perhaps
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: How to combine multiple ideas

    Administrative Note:

    Hi and welcome
    although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
    So, please update your profile to something more precise then "Earth" ( country will suffice, no need to be more precise).
    Thank you for helping us to help you

  5. #5
    Registered User
    Join Date
    12-05-2011
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: How to combine multiple ideas

    LOL copy that

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Comparing Multiple Columns Ideas
    By dodgemain in forum Excel General
    Replies: 2
    Last Post: 10-25-2018, 02:11 AM
  2. [SOLVED] Multiple level Database ideas
    By lcartwright in forum Excel General
    Replies: 4
    Last Post: 03-09-2015, 08:12 PM
  3. [SOLVED] Methodology for combining multiple forecasts into one - ideas
    By Vaslo in forum Excel General
    Replies: 3
    Last Post: 09-29-2014, 10:33 AM
  4. Ideas on how to track weekly trends from multiple files
    By Nurseryboy in forum Excel General
    Replies: 3
    Last Post: 08-03-2013, 04:03 AM
  5. [SOLVED] Need my SUM IF Frequency Match formula to combine with cell references - ideas?
    By acillatem in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-28-2013, 09:04 AM
  6. [SOLVED] Using Combine macro to combine multiple worksheets - need to modify to paste formulas
    By DLSmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 09:07 AM
  7. ideas to generate multiple reports from data table
    By nickybrandi in forum Excel General
    Replies: 0
    Last Post: 09-22-2011, 07:57 PM

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