+ Reply to Thread
Results 1 to 4 of 4

If formula with a character removed?

  1. #1
    Registered User
    Join Date
    07-03-2018
    Location
    Victoria, BC
    MS-Off Ver
    2013
    Posts
    2

    If formula with a character removed?

    Hi all,

    I am using an "If" formula here, I think.

    I have two columbs of work I need to reference.

    For example:

    Cell J2 will have in it "5293 - Meeting Minutes" and cell L2 will have "#5293 - Meeting Minutes"

    There are hundreds of lines of data and it's a pain in the you-know-where to eyeball to make sure if all of these match up.

    So I want to create a formula that will remove the "#" the L column so that I can do a formula like this below and copy/paste everything down (I probably need to copy and paste this into another cell, I would assume) so that I can have a formula in another cell that will allow me to show something like this:

    =IF(J2=L2,"OK","CHECK")

    Does that make sense?
    Maybe I haven't had enough coffee today.

    Thanks!
    Favs

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: If formula with a character removed?

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


    Kind regards
    Leo

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: If formula with a character removed?

    Or try:

    =IF(J2=SUBSTITUTE(L2,"#",""),"OK","CHECK")

  4. #4
    Registered User
    Join Date
    07-03-2018
    Location
    Victoria, BC
    MS-Off Ver
    2013
    Posts
    2

    Re: If formula with a character removed?

    Both formulas worked. Thank you so much for your speedy assistance

+ 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. Simple formula removed....result shown instead
    By trolle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2017, 02:05 AM
  2. How to prevent formula being removed from cells...
    By dori2o in forum Excel General
    Replies: 2
    Last Post: 03-31-2016, 12:14 PM
  3. [SOLVED] returns a result and removed the formula
    By Hanif13 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2014, 02:00 AM
  4. Maintain formula if sheet removed
    By rybussell in forum Excel General
    Replies: 1
    Last Post: 02-27-2013, 12:47 PM
  5. whi is formula removed but cell value remaining?
    By brillison in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2009, 01:10 PM
  6. HELP!!! Formula removed after DataRange refresh
    By bvolman in forum Excel General
    Replies: 3
    Last Post: 01-20-2007, 11:56 AM
  7. [SOLVED] format a cell if the formula is removed
    By Rob in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-19-2006, 11:35 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