Timeline for Problems on RIGHT function on Sharepoint
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 10, 2020 at 14:36 | comment | added | MarkR |
I tryed to use =LEFT(KgTeoRien, LEN(KgTeoRien)-3) on a not calculated table, and it give me a #VALUE! error
|
|
| Jan 10, 2020 at 14:08 | comment | added | MarkR |
Yes I know it but if I use comma, the error says "The formula contains a syntax error or is not supported." On excel formula in Italy I use ; separator.
|
|
| Jan 10, 2020 at 13:54 | comment | added | Raf | docs.microsoft.com/en-us/previous-versions/office/developer/… | |
| Jan 10, 2020 at 13:25 | comment | added | MarkR |
If I use comma, it gives me a Microsoft error. Formula works only with ;
|
|
| Jan 10, 2020 at 13:15 | comment | added | Raf |
@MarkR Please use , instead of ; in formula. Should be =LEFT(KgTeoRien, LEN(KgTeoRien)-3)
|
|
| Jan 10, 2020 at 13:12 | comment | added | MarkR | I updated my screen on the main post, check it please :) | |
| Jan 10, 2020 at 13:01 | comment | added | Raf | @MarkR look on my screens. As you can see It does not convert to 1637037,03703. It removes last 4 characters from right. | |
| Jan 10, 2020 at 12:58 | comment | added | MarkR |
It doesn't work. It convert it like this: 1.637.37 to 1637037,03703
|
|
| Jan 10, 2020 at 12:43 | comment | added | Raf | @MarkR I've updated my answer. | |
| Jan 10, 2020 at 12:43 | history | edited | Raf | CC BY-SA 4.0 |
added 94 characters in body
|
| Jan 10, 2020 at 12:35 | review | Low quality posts | |||
| Jan 10, 2020 at 14:38 | |||||
| Jan 10, 2020 at 12:26 | comment | added | Raf | @MarkR you need to use LEFT function to leave left part and exclude right part. | |
| Jan 10, 2020 at 12:24 | history | edited | Raf | CC BY-SA 4.0 |
added 172 characters in body
|
| Jan 10, 2020 at 12:22 | comment | added | MarkR | No, in my example I need to remove 4 char from right. 1.637.037 to 1.637 (or 1.637,00) | |
| Jan 10, 2020 at 12:18 | history | answered | Raf | CC BY-SA 4.0 |