Translation From Deutsche To English

Mar 26, 2006

I have excel files which has text written in deutsche(german).
am trying to write a code which can convert this text to english.

have also found a reference from this forum
[url]
But this doesnt seems to be working for me.

View 9 Replies


ADVERTISEMENT

Translation Tool

Dec 17, 2006

I am trying to create a simple translation tool for my product catalog, which is in Japanese, to English.

I have the Japanese and the English terms listed in a file (say, File A) in Col A and Col B which will keep increasing every week.

I want to create a macro which goes thru this list and replaces ALL the Japanese terms to English in "ALL THE SHEETS OF THE PRODUCT CATALOG" (say, File B) .

I have created a button in File A so that when I press this button, I browse my computer, select the file (product catalog) to be translated, replace all the Japanese terms to English terms in ALL THE SHEETS and saves it under a different filename.

View 14 Replies View Related

Language Translation In Excel

Apr 24, 2006

I have a list of English words (about 2500) that are listed in excel in column A. In column B I'd like the Portuguese translation.

The best I've got so far is to have a hyperlink in column B -

=HYPERLINK("http://www.ultralingua.net/index.html?action=define&sub=1&nv=0&searchtype=stemmed&text=XXXXXX&service=english2portuguese",
"ultralingua").

Where I've typed 'XXXXXX' this is the word that will be translated in
ultralingua.

Is there any way that XXXXXX can be replaced with the contents of a source cell i.e. so ultralingua translates the contents of one of the cells from column A? I'll the transcriibe the result into column B.

View 6 Replies View Related

Translation For Column With Numbers

Dec 7, 2011

I have a list of numbers in a column. The column looks like this:

CodeA
1 5 7
1 2
3 4
2 6
4 5

I need the column to be translated using the code below, so for instance Row 1 would be Toys, BubbleGum, Cookies

1 = Toys
2 = Candy Canes
3 = GumDrops
4 = Chocolates
5 = BubbleGum
6 = Mints
7 = Cookies

Is it possible to count these individual items in the cells, even though there are more then 1 thing in a cell?

View 1 Replies View Related

Text Matrix Translation

Jul 25, 2007

i have a text file with the following data

12345
-----
A |xxxxx
A1 |.x...
A2 |..x.x

I need to get an output better on text (excell is limited with rows and the matrix can have up to 5000 rows and lines)
i tried to open the file with excel but every line is a string and i can't separet it

the output will be

A 1,2,3,4,5
A1 ,2,
A2 ,3, ,5

it will save me a lot of time

View 9 Replies View Related

Translation Of HTML Cell Data When Exporting As TEXT

May 2, 2006

I have a cell in which I have the following data (for example):

<a href="http://www.trucks.com">Ford Trucks</a>

I need to export the sheet as a tab delimited txt file for import into another program. When excel saves the file as .txt, it add extra data so that the cell is represented as:

"<a href=""http://www.trucks.com"">Ford Trucks</a>"

Note the set of two additional inverted commas. This extra data interferes with the parsing of the data in the other program. I've tried formatting the cells to "general" and "text", however, it does not seem to affect the txt output.

View 9 Replies View Related

Table To English Converter?

Mar 8, 2012

So I have table that consists of several columns describing a single transaction. I want a macro to translate the (potentially thousands) of rows into a single cell for each row on another worksheet.

The rows need to be formatted by transaction type. The problem is that I know nothing of excel syntax .

I was thinking something along the lines of a case loop, if possible:

Case D1 = BUY
Output("You bought ("C1") on ("A1") for the amount ("E1")")
Case D1 = SELL
Output("You sold ("C1") on ("A1") for the amount ("E1")")
etc.

How would I get that into workable excel code, if possible?

View 2 Replies View Related

American / English Dates

Feb 7, 2008

I have US reporting package that e-mails a report, which I then run macros to put extract the required data, and pivot etc...

There can be anwhere between 1 and 15,000 lines of data.

The file is generated as a CSV file, with dates in the first column in the format mm/dd/yyyy. Other header information also has a "/" so it is impossible to do a text to columns.

I need to continue using UK dating format, so cannot change the Excel settings.

Can anyone provide me with VBA code to convert mm/dd/yyyy into dd-mmm-yyyy without it ignoring any dates where the dd is less than 12?

View 9 Replies View Related

Convert All Arabic Letters Into English?

Jun 26, 2014

I want to convert all the Arabic letters into English (ie. Translitertaion) Not translation. I have found the below sample code in google and I have just tested but it is not working

Const cyr = "123456789" 'the cyillic alphabet in order
Const lat = "abcdefghi" 'the latin alphabet in the same order
Function convertchar(inchar As String) As String
Location = InStr(cyr, inchar)

[Code]....

If I type any number in cell A1 and run the above convertcells, it is not converting to latin.

View 1 Replies View Related

HTML Encoding On Non-english Characters

Nov 8, 2013

I have an excel file which I really need to encode non english characters as when I import it into our system all special characters return as �

The problem is I need it to work similar to how this works: Unicode to HTML converter

It only encodes standard text, leaving the HTML intact, and only converts non-english characters such as UTF-8 etc...

I have tried setting the encoding when saving to a CSV file as UTF-8 however still no luck.

View 9 Replies View Related

Convert Dates To English Words Using VBA

Dec 23, 2013

how to convert dates to text without using addon, using VBA. like 23/12/2013 to Twenty third december, two thousand thirteen,

View 1 Replies View Related

Display Date/Time In English

Oct 16, 2006

How to display following, that the day and month will apear in English, w/o relation to current regional settings:

Format( Date, "Long Date") & ", " & Time

View 9 Replies View Related

Converting A Number In Digits To Its English Representation

Jul 28, 2008

a2 needs to contain a number (multiple of 10 10-90) and then d2 must contain a formula that gives that number in word form.

I need to do the same thing in b2 and e2, only with a number 20-99 not neccesarily ending in 0.

View 9 Replies View Related

Changing From Norwegian To English Numbering Format?

Nov 6, 2013

I have several graphs in excel which has the percentage number as follows: 15,5 %. I want to convert the number to 15.5 % so it is in line with the english language.

View 1 Replies View Related

English VB Code 100% Convert Numbers To Text?

May 7, 2014

I would like to share with you this VB Code

convert number to text ( Convert Numbers to Text.) I hope you like it

Add it to add-in to be able using it in all excel sheets.

View 1 Replies View Related

How To Force TEXT To Return Date In English

Feb 6, 2014

I have a formula as follows:

Code:
=TEXT(A1,"Mmm YY")

Where cell A1 contains a date, say 01/01/2014.

For me this returns "Jan 14." However, I have a colleague using a Spanish version of Windows/Excel and therefore it displays this in Spanish as "ene 14."

How can I force the formula to return the English spelling, Jan 14?

View 2 Replies View Related

Using Analysis Toolpak Functions On Non-English Version

Feb 28, 2007

A workbook was created using the English version of Excel. It uses Analysis Toolpak functions.

When the workbook is opened on a Spanish version Excel system, embedded functions - like IF, AND, OR translate to Spanish. Other functions, like NETWORKDAYS, do not.

Any cross-language users have a tool for this? Other than doing a Find/Replace or creating custom functions.

View 9 Replies View Related

Convert Multi Language File To English

Apr 30, 2008

A co-worker has an excel file that has both English and Chinese words in it. We need to convert the Chinese text to English. The contents of the files are sensative so I cannot share a copy. how to correct this?

View 2 Replies View Related

Excel 2010 :: Save CSV File With Non-English Characters?

Dec 5, 2012

I run excel 2010... I have xls file (see file attached) with both English and Non English characters.

When I save this file as xls or xlsx - everything is good, but when I save the file as CSV and try to open it later - I see that the English characters stays the same but the non English characters become gibberish.

How can I save a file (that include some non English characters) as CSV without loosing the non English characters? Is there a way to do that from within the excel 2010 menus? Or maybe there is an external tool?

Attached file : 913365454523.xls‎

View 1 Replies View Related

Works With US English Settings, Errors If Italian Settings

May 19, 2008

The following line of VBA code executes properly if machine settings are US English, but throws a "Run-time error '1004': Application-defined or object-defined error" ? ...

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved