Results 1 to 7 of 7

help in substitute function / formulae

Threaded View

  1. 01-24-2017, 12:57 AM #1
    jilaba
    jilaba is offline
    Forum Contributor
    Join Date
    02-27-2009
    Location
    Chennai, India
    MS-Off Ver
    Excel 2013
    Posts
    327

    help in substitute function / formulae

    ref. attachment.

    cells have data such as 0.45.5
    i used substitute function to make them as 0.455

    when a cell contains no data (blank) it brings "value" in the result cell. I want to make it as blank.
    Attached Files Attached Files
    Ask me how to hate XL.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combining Formulae with INDIRECT and SUBSTITUTE
    By AliGW in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2015, 11:05 AM
  2. Substitute Function
    By llbean1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-05-2014, 04:53 PM
  3. [SOLVED] Is there another way to write INDEX(INDIRECT(SUBSTITUTE()),MATCH(OFFSET(SUBSTITUTE()))?
    By keby1nko in forum Excel General
    Replies: 4
    Last Post: 10-28-2014, 11:04 PM
  4. [SOLVED] SUBSTITUTE Function
    By Onceageordie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-23-2013, 09:26 AM
  5. substitute function
    By mrggutz in forum Excel General
    Replies: 2
    Last Post: 02-18-2011, 08:54 AM
  6. how to resolve this after Substitute function?
    By stan123 in forum Excel General
    Replies: 12
    Last Post: 03-02-2007, 04:51 PM
  7. [SOLVED] Substitute worksheet function
    By SIGE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2005, 05:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1