View original (French)

Reducing the number of digits in a column.

Solved
SB29 -  
 SB29 -
Hello,

In Open Calc, I have a column with a SIRET consisting of 14 digits. For example, 25345678900019. I want to create a new column that only contains the first 9 digits of the SIRET, which will be titled SIREN. I have a total of a column with 700 SIRET initially. Could you guide me on how to automatically convert the 700 SIRET with 14 digits into 700 SIREN with 9 digits?

Thank you in advance.

2 réponses

Réponse 1 / 2
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 509
 
Hello,

To try

=LEFT(SIRET cell;9) to be extended over the 700 lines

Best regards
1
SB29
 
Sure. It works, but in the response, you need to replace the term "cell" with the OPEN OFFICE reference of the cell to be modified. For example, =LEFT(B21;9)
0
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 509
 
That's why I put it in italics and underlined it.
Best regards
0
Réponse 2 / 2
SB29
 
Thank you, you are absolutely right and I didn't get it. I apologize. I'm not yet familiar enough with Open Office.
0