+ Reply to Thread
Results 1 to 3 of 3

Text functions -- translation tables and dupilcates

  1. #1
    Registered User
    Join Date
    03-01-2015
    Location
    Pittsburgh, PA
    MS-Off Ver
    Pennsylvania
    Posts
    1

    Text functions -- translation tables and dupilcates

    My table is currently translating phrases in an English catalog to 10 different languages.

    My table is set up so that the English phrases go downward and each language is a column across ex. Dutch/German/Spanish/ect.

    For example, A2 is Hello, then B2 is "Hola"

    ENGLISH SPANISH FRENCH ECT ECT
    Hello Hola Bonjour
    Goodbye Adios Au reviore
    ect
    ect
    Hello
    Goodbye

    But there may be 15 Hello's down the English column. Instead of tediously copying and pasting Holas and Bonjours in each cell, is there a function that can make Hello become Hola in all instances in Row B ONLY?

    It could only apply to one row, because if Row C is French, it would need to say "Bonjour" for all instance of hello.

    So I need to make one cell with text equal another cell with text (A1=B1, in all instances of row B only, and so on and so forth

    Thank you for your help. Is there any way I can send my sheet as an attachment to help?

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Text functions -- translation tables and dupilcates

    Yes to attach your file, click "Go advanced" button, next to "Post Quick Reply", and then you will find paperclip image button to attach file.

    regards

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Text functions -- translation tables and dupilcates

    Hi, welcome to the forum

    Are you saying that you will have text in all those cells, but in some cells, you want a formula to check for repeats?

    If thats what you are asking, then no, a cell can contain either data or a formula - not both.

    Why dont you try and IF the duplicate rows and just delete them?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Real time text translation to match the language selectedin language vailidation
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2013, 09:23 PM
  2. Excel 2007 : Using data tables and IF functions
    By geovannavp in forum Excel General
    Replies: 0
    Last Post: 10-25-2011, 03:03 AM
  3. Removing Dupilcates formula not working anymore
    By jktyler in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-18-2011, 04:27 PM
  4. Consolidate and Remove Dupilcates
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2011, 03:34 PM
  5. Functions and Pivot Tables
    By mcooper1975 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-02-2009, 07:02 PM

Tags for this Thread

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