+ Reply to Thread
Results 1 to 4 of 4

Replace number by text deppending of number

  1. #1
    Registered User
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    56

    Replace number by text deppending of number

    Hi everyone,

    In sheet I send you what I would like is to know how to put a formula when I write in "J8...9..10...." a number it replace for the text corresponding in colluns O/P.

    For example if I write in "J8" - "1" automatic it replace in "J8" for "Water"...

    Thanks in advance
    Miguel
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    1,965

    Re: Replace number by text deppending of number

    I dont think you can do it in the same cell.

    to write something that will change itself in the same cell it is entered.

  3. #3
    Registered User
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    56

    Re: Replace number by text deppending of number

    Is there any possibility to do it in a simple way ????
    For example if I write the number in Collun "I" to appear the text in "J" ???

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    1,965

    Re: Replace number by text deppending of number

    A vlookup..

    I8=1
    J8 = VLOOKUP(I8,$O$8:$P$12,2,0)

+ 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] Find number in parenthesis and replace with text and increasing number
    By lamdathoa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2020, 10:09 AM
  2. [SOLVED] Replace text in one sheet with number value from another
    By MCDForm in forum Excel General
    Replies: 6
    Last Post: 09-23-2017, 03:43 AM
  3. How to Replace a Number with Text?
    By IPerry92 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2015, 12:36 PM
  4. How do I replace the number values with corresponding text ?
    By paul_drive in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-22-2013, 01:42 PM
  5. [SOLVED] Replace text number with some other number based on the sheet
    By amandeepsharma89 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2013, 09:52 PM
  6. [SOLVED] Replace a number with text
    By Candy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2005, 01:05 PM
  7. [SOLVED] Replace Number with Text using Macro
    By Carter68 in forum Excel General
    Replies: 3
    Last Post: 04-19-2005, 04:06 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