Description
Identify the language used in a specified text using Microsoft Translation Services.
NOTE
- This function is a service backed function. The supported languages and results may vary as languages are added or removed.
Syntax
Copied!=DETECTLANGUAGE(text)
SAMPLE data
| | A | B | C | D | E |
|:---:|:----|:----|:---------|:----|:----|
| 1 | | | | | |
|-----|-----|-----|----------|-----|-----|
| 2 | | | | | |
|-----|-----|-----|----------|-----|-----|
| 3 | | | Hello | | |
|-----|-----|-----|----------|-----|-----|
| 4 | | | Xin chào | | |
|-----|-----|-----|----------|-----|-----|
| 5 | | | Hallo | | |
|-----|-----|-----|----------|-----|-----|
| 6 | | | | | |
|-----|-----|-----|----------|-----|-----|
| 7 | | | | | |EXAMPLE 1
Copied!=DETECTLANGUAGE(C3:C5)
| | A |
|:---:|:----|
| 1 | en |
|-----|-----|
| 2 | vi |
|-----|-----|
| 3 | de |