+ Reply to Thread
Results 1 to 9 of 9

Replacing a cell in a formula by an other

  1. #1
    Registered User
    Join Date
    05-12-2016
    Location
    Canada
    MS-Off Ver
    Microsoft Office Famille et Étudiant 2019
    Posts
    26

    Replacing a cell in a formula by an other

    Here's my problem. I have several long formulas that I need to adapt one by one in order to obtain the desired result. Here is an example of a formula using "IF" (which is "SI" in French).

    =SI(C33=1;$TM$26;SI(C33=2;$TM$27;SI(C33=3;$TM$28;SI(C33=4;$TM$29;SI(C33=5;$TM$30;SI(C33=6;$TM$31;SI(C33=7;$TM$32;SI(C33=8;$TM$33;SI(C33=9;$TM$34;SI(C33=10;$TM$35;SI(C33=11;$TM$36;SI(C33=12;$TM$37;SI(C33=13;$TM$38;SI(C33=14;$TM$39;SI(C33=15;$TM$40;SI(C33=16;$TM$41;SI(C33=17;$TM$42;SI(C33=18;$TM$43;SI(C33=19;$TM$44;SI(C33=20;$TM$45;SI(C33=21;$TM$46;SI(C33=22;$TM$47;SI(C33=23;$TM$48;SI(C33=24;$TM$49;SI(C33=25;$TM$50;SI(C33=26;$TM$51;SI(C33=27;$TM$52;SI(C33=28;$TM$53;SI(C33=29;$TM$54;SI(C33=30;$TM$55;SI(C33=31;$TM$56;SI(C33=32;$TM$57;SI(C33=33;$TM$58;SI(C33=34;$TM$59;""))))))))))))))))))))))))))))))))))

    In this fomula, I wish to modify all the "TM" into "UF" without having to manually change them one by one. Is there a speedy way to do this? Thanks!
    GO! WINGS! GO!

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Replacing a cell in a formula by an other

    Hi,

    Yes, this can be done with a Find and Replace.

    Find what: $TM$
    Replace with: $UF$

    Hope this is helpful

  3. #3
    Registered User
    Join Date
    05-12-2016
    Location
    Canada
    MS-Off Ver
    Microsoft Office Famille et Étudiant 2019
    Posts
    26

    Re: Replacing a cell in a formula by an other

    Cool! I'll try this out later this evening. Thank you for your reply (you have just saved me a whole lotta work)! THANKS!

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,469

    Re: Replacing a cell in a formula by an other

    reading your question I think you also have to take a look at Vlookup, since your used 33 or 34 if statements.

    without seeing a small part of the excel file, without confidential information it is hard to advice for your situation.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Replacing a cell in a formula by an other

    @oeldere makes an excellent point. You would be better served with using VLOOKUP.

    See attached example.
    Attached Files Attached Files

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Replacing a cell in a formula by an other

    ..or perhaps even simpler

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

  7. #7
    Registered User
    Join Date
    05-12-2016
    Location
    Canada
    MS-Off Ver
    Microsoft Office Famille et Étudiant 2019
    Posts
    26

    Re: Replacing a cell in a formula by an other

    I'm familiar with VLOOKUP. And yes, it could be used as an alternate way to run my program. However, I'm not familiar with the INDEX formula. I'll look into it.

    Also, I tried FIND AND REPLACE earlier this morning... YEAH BABY!!! It works real nice! I knew there was a simplier way to get things done, I just didn't know how. Many thanks to SOUTHWARD!

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,469

    Re: Replacing a cell in a formula by an other

    You're welcome. We appreciate the feedback!

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

    It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

  9. #9
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Replacing a cell in a formula by an other

    Glad I could be of some 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. Replies: 5
    Last Post: 01-27-2016, 11:06 AM
  2. [SOLVED] Replacing formula with $ variable cell reference
    By PQK78 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-17-2015, 12:14 AM
  3. Replacing cell value without replacing formula in the cell
    By kingoftheace in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2012, 06:28 AM
  4. Is there a formula for replacing a symbol with text from another cell?
    By alannanoelle in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-20-2012, 07:12 PM
  5. Replacing a formula with another cell
    By help000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-20-2008, 11:25 AM
  6. Replacing "0" values with null string in array while preserving cell formula
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2007, 01:07 PM
  7. Replacing data using the cell value not the formula
    By Hunter1978 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2006, 05:20 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06876 seconds
  • Memory Usage 9,107KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (9)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (9)postbit_legacy
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • bbcode_parse_start
  • postbit_imicons
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1