english

Hello Folks. I used to export tables in PDF to excel. Sometimes all the words in the columns saved as a single cell. This cell is always the last used row. Each word is separated by space and Dot (.) in their respective columns. Now i want to move the words downward in their respective columns...

Hello, I have an inventory list of items, that combines both chinese and english descriptions into it. Is there anyway I can separate them using formulas? The ??? are the chinese characters which may appear before or after then english description. Thank you Sheet1 <colgroup><col...

Is there a code I could run that would translate an entire spreadsheet from French to English please?

I have Thai characters and English characters in a cell, I want to remove Thai and keep only English what do I need to do? Please help

I have created a quote builder for our organisation which is in English and like to be able to translate the quote (which can be dynamic) from English to Portuguese using VBA. I don't want to use google translate as it involves a cost and the spreadsheet requiring conversion has formulas and...

I have a two option buttons (form control) located on three different worksheets in the same workbook. They are: English French They are connected to a macro that - if English is selected, hides rows that are in French and unhides any hidden rows that are in English. This is done on all...

Hello there, I’m not sure if I’m on the right place here with my question. If not, please excuse the circumstances. I just installed Excel 2016 in English on my PC. It runs on a german Windows 10. Excel does nearly all good in English, but for little things like the date-formatting I...

Hi Row 1 has my headers. Starting in A1 and working to the right, we have "Names", "Gender", "Language", "Talks", "Demonstrations" respectively. Suppose I have a list of 100 names in column A, then column B will be either male or female, Column C will be English or Portuguese, Columns D & E...

So I have this problem when importing a csv file, one cell has information that needs to be split into columns or repeated with the same tablet id. I have tried several combinations but everything takes time and it is not clean and it doesnt solve the problem, any ideas data is below and the two...

Hello i need some help with a table, it goes like this: I need to show me on A, how much money have left when the filtered data from C, the max allowed money is on E. Sorry for bad english. The sheet is annexed. For example, if i filter "Publicidade" on C, it show me on B all the money i...

hi I am devising a school marksheet in excel I have 21 subjects including maths French and english which are mandatory subjects. all tudents do maths English and French . hence 18 columns with different subjects left .only 5columns out of the 18 are filled as there are many options and a...

The problem I am trying to solve is to write a macro, that copies their name against each course they attend. I have over 600 students, and the student names change on a monthly basis. There is always a space between the last course and next student name. Any pointers welcomed! <tbody> Column...

Hi Guys I need some help with this formula =IF(A1="chinese",8,0),IF(A1="English",8,0),IF(A1="Spanish",8,0) How do I continue the formula if the cell A1 name changes to let say English or Spanish etc.. Thanks in advance Larry

Hi all, I'm trying to enter a Countif formula to add up the number of instances 'HL' appears in a number of cells across a row, but it keeps returning an error message, the error says i have used too many arguments for this function. The formula i am trying to use is...

Hi there, hope someone can help... The names of the worksheets are irrelevant, however I'm keen to know what the following means in plain English. Specifically around the comma? =AND($J$14>'Project Sold Effort'!$AI$40,$J$14<='£ Calculations (Ref Only)'!$I$4) Thanks

Hello friends. I have a code i used in several worksheets, however some are german french and english - how do i make sure the same code works in all - or alternatively, how do i figure out the other language variations to the same code? The code is below and works fine in english excel but not...

Hi Folks, Can you please help me with the below query: Master Data: <colgroup><col><col span="2"></colgroup><tbody> Username Subject Score A1 English 50 A1 Maths 45 A1 Physics 34 A1 History 23 A1 Geography 56 A2 English 24 A2 Maths 67 A2 Physics 45 A2 History 32 A3...

Hello, I was trying to change the language for my Excel workbook and encountered a problem. If I just change the language from Dutch to English in the settings menu I have to choose to make it the default language, but is there a way to just change it for that particular workbook? If I choose...

Hi All I am sure this is possible, so hopefully you can help I am trying to translate UK English To US English for a program that uses Excel for content translations 1 sheet has all my content in cells (sentences) Another I have a column "A" UK words and "B" US Words I need a formula please...

Hi All I am sure this is possible, so hopefully you can help I am trying to translate UK English To US English for a program that uses Excel for content translations 1 sheet has all my content in cells (sentences) Another I have a column "A" UK words and "B" US Words I need a formula please...